This tutorial will explain how to delete duplicate records in a MySQL table while picking which record will be used as the single record. Since MySQL 5.1 there has been a feature for ALTER to IGNORE duplicate records when creating a unique index, but there are a couple of problems with using this extension.
HELP WANTED: My new website involves movies, television and video games. I need people to give the early beta a shake down. Please visit www.cgTag.com and sign up for beta access. Thank you!