Check Duplicate in MySQL

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

June 21, 2011 · 1 min · Shern Shiou Tan