Dental Articles - Edmonton

Compare tables find and update in MySQL

Posted by negraru on Thu, 22 Jun 2017

Compare two tables find and update only matching data in MySQL

Find:

SELECT id, mailing 
FROM directory_list a 
JOIN email_temp b ON a.email=b.email;

Update:

UPDATE directory_list a 
JOIN email_temp b ON a.email=b.email 
SET mailing = concat(COALESCE(mailing, ''), ' --text--');

Designer Edmonton