mysql - php missing entries in database -

i have 2 mysql tables shown. want code print 11 cow missing entry in 2 tables.since catdog has word dog similar.

table 1

amount des     11 catdog     11 cow

table 2

amount des     11 dog

try this:

select table1.* table2 right join table1 on table1.des concat('%', table2.des, '%') table2.des null;

Braziel