How to find the duplicate values in MySQL
Posted by navaneeth on Nov 14, 2012 in MySQL, Php | No comments yet

In this post we are discussing about how to find the duplicate values in MySQL. There are a lot of scenarios in which we found this post helpfull.We can find the duplicate values in in MySQL table using the SELECT Query
SELECT column_name, COUNT(*) c FROM table GROUP BY coloumn_name HAVING c > 1;
This will return a result with the column_name value in the first column, and a count of how many times that value appears in the second.
That’s it and hope this post help you to know how to find the duplicate values in MySQL
Leave a Reply