May 152010
Find duplicated records in MySQL
Answer:
Assume you have a table `my_table` which contains a column called "name", how do you find what name has been duplicated in your table?
SELECT name, COUNT(`name`) as cnt
FROM `my_table`
GROUP BY `name`
HAVING cnt > 1
That's all.
