Re: Comparing multiple Mysql tables to find duplicates
| From: | Raditha Dissanayake | Date: | Fri, 30 Jan 2004 18:13:47 +0000 |
| Subject: | Re: Comparing multiple Mysql tables to find duplicates | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176375@lists.php.net to get a copy of this message | ||
Did you mention cofee John? now why did i suggest subselects when good old joins seem to do the tricks. Yikes!
John W. Holmes wrote:
From: "Chris Bruce" <chris@idextrus.com>-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.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...