Please wait while we load your page...


Webmaster Tutorials

Webmaster Tutorials

Find Duplicate Values in Table
You can find duplicates by executing the following mySQL query (via command line or app like phpMyAdmin):

SELECT  * FROM  table tbl1 WHERE EXISTS (SELECT 1 FROM table tbl2 WHERE tbl1.column = tbl2.column LIMIT 1, 1) ORDER BY column

- Replace table with the name of your database table.
- Replace column with the name of the column in the database table you are looking for duplicates

Last Revised: 2015-09-30 11:42:07

Live Chat Not Available