Comparing multiple Mysql tables to find duplicates
| From: | Chris Bruce | Date: | Fri, 30 Jan 2004 17:32:02 +0000 |
| Subject: | Comparing multiple Mysql tables to find duplicates | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-176366@lists.php.net to get a copy of this message | ||
Hello everyone,
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?
Thanks.
Chris