Return to Snippet

Revision: 67319
at September 9, 2014 05:57 by flatearthcomms


Initial Code
SELECT my_column, COUNT(*) as count
FROM my_table
GROUP BY my_column
HAVING COUNT(*) > 1

Initial URL
http://snippets.khromov.se/check-if-column-in-mysql-table-has-duplicate-values/

Initial Description
Mysql find duplicate values in field

Initial Title
Mysql find duplicate values in field

Initial Tags
mysql, find

Initial Language
MySQL