Find duplicate mysql field vale - MySQL Snipplr Social Repository

Revision: 64649

at September 3, 2013 02:16 by flatearthcomms

Initial Code

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

Initial URL

http://stackoverflow.com/questions/688549/finding-duplicate-values-in-mysql

Initial Description

Prints out a list of any field containing duplicates with count

Initial Title

Find duplicate mysql field vale

Initial Tags

mysql, find

Initial Language

MySQL