Insert ignore with conditional

Question

I need to insert some records which might have duplicates. Column to overwrite/skip is mytable.email and mytable.fooFlag should be 1.

I came up with something like this:

INSERT IGNORE INTO mytable  
VALUES ('somemailaddress')  
ONLY IF 'somemailaddress' DOES NOT EXIST  
AND fooFlag = 1

Answer 1

If email is UNIQUE, that's what "INSERT IGNORE" is for!

If email is UNIQUE and you want to 'update' some other fields when it is already in the table, then that's what "INSERT ... ON DUPLICATE KEY UPDATE" is for.

Answer 2

INSERT  INTO mytable (email)
SELECT sourcetable.email FROM sourcetable
WHERE sourcetable.email NOT IN (SELECT mytable.email from mytable where mytable.fooflag=1)