php - MySQL find only different in 2 table -

php - MySQL find only different in 2 table -

i have 2 table in mysql. table1 , table2.

in table1 number, email , phone number. in table 2 same, sometime different email or phone number. want list of records number same , email or phone number different. sometime both email , phone number different. tnx.

you can join tables, filter accordingly:

class="lang-sql prettyprint-override">select * table1 bring together table2 using (number) table1.email <> table2.email or table1.phonenumber <> table2.phonenumber

php mysql