Anyone know if it's possible to delete almost duplicate entries? Like if I have a table with 4 fields, one of which is an ID (auto_increment), is there a standard algorithm to delete rows that match the 2nd,3rd, and 4th values of a particular row? I can just manually search for them, but there are about a million entries so if there's a method to accomplish this task that you know of, please inform me.
Thanks,
Mike
Thanks,
Mike