From: "Chris Bruce" <[EMAIL PROTECTED]> > I am trying to write a function that would compare one table to a > number of other tables in Mysql and remove any duplicates found. This > is for tables of email addresses where I want to remove any dups found. > > Example: > Master list - compare to list1, list2, list3, and so on and remove > matches found from list1, list2, list3 etc. *not* from Master list. > > Does anyone know of any such beast before I set out to reinvent it?
DELETE FROM list1 USING master_list, list1 WHERE list1.email = master_list.email Repeat for other tables. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
