RE: Possible in sql, or just move it to a language

2007-03-15 Thread Daevid Vincent
able2 FROM table1, table2 WHERE table1.bounce_email = table2.email http://dev.mysql.com/doc/refman/5.1/en/delete.html > -Original Message- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 15, 2007 12:20 AM > To: mysql@lists.mysql.com > Subject: Poss

Possible in sql, or just move it to a language

2007-03-14 Thread Scott Haneda
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 tabl