[Pugged] Duplicates

[Dave J. Hala Jr.]

I'm looking for an easier way to check for duplicates in a mysql table.

Here is my current process:

1. create a temporary table
2. read a record from the temporary table
3. search the original table for more than one match.
4. if there is more than one match, mark that record
5. show the dba the original record and marked record.
6. if dba selects the marked record delete it.
7. drop the temporary table


I seem to vaguely remember something in access that compared keys or
something. I remember it was a very, very simple thing that worked
really easily.
The pain of what I am doing is that I'm only looking for a match on any
one or more of a number of the fields in each record. I also need to
display the suspected duplicates so that someone can confirm it is
duplicate. Once it is confirmed, then it gets purged.

Anyone know of a better way?

:) Dave


-- 

"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and
the Ugly)"

OSIS
Dave J. Hala Jr.
641.485.1606