November 22nd, 2006
Cleaning duplicate records in MySQL easily
I was recently looking for a way to clean out a table of all records that had duplicate email addresses. To do this I used a SELECT inside an INSERT statement.
INSERT INTO subscribers(email) SELECT DISTINCT(email) FROM bad_temp