Question: how to remove dulicate email address from mysql? 

Answer: Okay instead of how to remove duplicate email address, try not allowing people to insert duplicate email address.\n\nTo 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...\n\nWhat you could do now to remove duplicate email address is do this...\n\nBut I don't know your table structure so it is gonna be assumptions now... \n\n- This will delete all entries that have a duplicate including the original\nDELETE FROM thistable \nWHERE count(emailaddress) > 1\n\n- To just delete the duplicate\nDELETE FROM thistable\nWHERE count(emailaddress) > 1\nORDER BY tableid DESC\nLIMIT 1\n\nWhat 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..\n\n\nI hope I helped..\n\nNOTICE: I wont be held responsible if anything goes bad...\nRemember to backup your database at all times when preforming the delete query...
This question from the Yahoo Q&A forum is categorized in the topic: Family & Relationships