Compare two tables in mysql

select * from table1 where name NOT IN (select name from table2)