Posted By

flatearthcomms on 09/03/13


Tagged

mysql duplicate find


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

philik


Find duplicate mysql field vale


 / Published in: MySQL
 

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

Prints out a list of any field containing duplicates with count

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

Report this snippet  

You need to login to post a comment.