Advanced Search

Find duplicate mysql field vale

/ Published in: MySQL
Save to your folder(s)
Prints out a list of any field containing duplicates with count

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.