Query for duplicate records
| From: | Ron Piggott | Date: | Sun, 17 Oct 2010 19:55:45 +0000 |
| Subject: | Query for duplicate records | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47390@lists.php.net to get a copy of this message | ||
Is there a query you could help me write a SELECT query that would search table
ministry_profiles for where column organization has the same organization
more than once? I am trying to delete the duplicate organization records, but I am working with
1,000+ businesses and I can't go through each record looking for duplicates.