This is a one off I need to do
Table1 has email addresses in it, table two also has email addresses in it.
table1 represents bounced emails that need to be purged from the database.
What I would like to do, is mark a field in table2, called needs_purging
to true, when there is a match from table
I'm just guessing at this, but I think this is a simple update:
UPDATE table1, table2
SET table2.needs_purging = 1
WHERE table1.bounce_email = table2.email
http://dev.mysql.com/doc/refman/5.1/en/update.html
You could also do this same logic with the delete I believe:
DELETE table2
