Locating Duplicates

[M2E]

What is the quickest/easiest way to extract duplicate information from a database?

I have a database which consists of users details including email addresses. Some email addresses are repeated, so now I want to search for these and then delete the duplicate?

Is there way to do this through the phpmyadmin/mysql control panel - or what query would i need to use?

Thanks in advance...

----Ment2Excel (M2E)----
--LEARN BY EXAMPLE--

 

[r937]

delete 
  from yourtable
 where primarykey not in
       ( select min(primarykey) 
           from yourtable
         group by email )

r937.com | rudy.ca