DELETE n1 FROM table n1, table n2 WHERE n1.id > 10000 AND n1.id < 11000 AND n1.id > n2.id AND n1.EMAIL = n2.EMAIL;

The above MySQL query will delete duplicate email addresses between the id’s 10000 and 11000. Breaking the query into blocks of 1000 id’s will reduce strain the MySQL server.

This entry was posted on Friday, December 9th, 2011 at 12:27 pm and is filed under Programming, Web. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.