Posted By

flatearthcomms on 09/03/13


mysql duplicate find

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Find duplicate mysql field vale

 / Published 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.