How to delete duplicate records in MYSQL with PHP.
Posted: Tue Mar 16, 2004 3:04 pm
Hi everyone,
I have a simple MYSQL table with about 4000 records. The only field is category. The data is category types, IE: restaurants, hairdressers, car dealers, etc. There are alot of duplicates and a lot of unique entries.
I have searched the web and here for about 2 hours on a simple way to either delete the duplicates, and leave an original. Or, create a new table from the existing one and only get unique entries.
I don't know quite how to do this. Any direction would be greatly appreciated.
Thanks in advance,
Dmacman
I have a simple MYSQL table with about 4000 records. The only field is category. The data is category types, IE: restaurants, hairdressers, car dealers, etc. There are alot of duplicates and a lot of unique entries.
I have searched the web and here for about 2 hours on a simple way to either delete the duplicates, and leave an original. Or, create a new table from the existing one and only get unique entries.
I don't know quite how to do this. Any direction would be greatly appreciated.
Thanks in advance,
Dmacman