Check Duplicate in MySQL

June 21, 2011 · 1 min · Shern Shiou Tan

Simple snippet:

SELECT `name`, COUNT(`name`) as cnt
FROM `members`
GROUP BY `name`
HAVING cnt > 1
ORDER by cnt;