Finding duplicate values in MySQL SELECT `name`, COUNT( * ) c FROM `table` GROUP BY `name` HAVING c >1