MYSQL remove duplicates
Posted on 2014-10-09
Hi All I know this is really simple but im a bit of a dunse with MYSQL so wanted a bit of advice, I have a table "Activefeed" which has a coumn in it "email". I would like to remove all of the rows which have a duplicate email addresss, i.e if there are 2 rows with the same email address delete on of the rows and so on. I thought this would of been easy but there is a lot of different options which creating and removing rows etc, all I want to end up with is my table "activefeed" to effectively be cleaned and only have 1 row per email address and all duplicates deleted.
Apologies but in your answer can you treat me like an idiot ;)