A quick method to remove duplicate records from your database: ALTER IGNORE TABLE tablename ADD UNIQUE INDEX dublicatedindex (fieldthatcontaindoubles); ALTER TABLE tablename DROP INDEX dublicatedindex The method above will remove dublicates and will add a Unique key to the field...Read More