text: how to remove dulicate email address from mysql?   okay instead of how to remove duplicate email address, try not allowing people to insert duplicate email address.  to ensure that, you need to make the emailaddress field in the table as unique index... once you do, noone could insert the same email address...  what you could do now to remove duplicate email address is do this...  but i don't know your table structure so it is gonna be assumptions now...   - this will delete all entries that have a duplicate including the original delete from thistable  where count(emailaddress) > 1  - to just delete the duplicate delete from thistable where count(emailaddress) > 1 order by tableid desc limit 1  what this does, it deletes every email address that duplicates where the tableid (primary key) is the newest and i just want 1 so the other will stay inside the database..   i hope i helped..  notice: i wont be held responsible if anything goes bad... remember to backup your database at all times when preforming the delete query...