Mysql find duplicate values in field - MySQL Snipplr Social Repository

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