Hi,
I am importing a lot of emails into a MySQL database using a custom script I made. Anyway - I imported 4.6MB of email, and I think there might be some dupes in there.
What would be the best way to go about removing dupes from the database. I want to try and use a SQL query rather then a PHP one...
What have should have done was done a search for each email before I added them, and if it was already there not added it, but I was lazy and didn't...
Any advice as to what I should do? Thanks in advance.
Michael Bray
I am importing a lot of emails into a MySQL database using a custom script I made. Anyway - I imported 4.6MB of email, and I think there might be some dupes in there.
What would be the best way to go about removing dupes from the database. I want to try and use a SQL query rather then a PHP one...
What have should have done was done a search for each email before I added them, and if it was already there not added it, but I was lazy and didn't...
Any advice as to what I should do? Thanks in advance.
Michael Bray
Removing Dupe Entries in MySQL.