Please wait while we load your page...

PasswordSentry

Latest Version [8.00202205221] Last Updated [May-22-2022]

Webmaster Tutorials

Definition [Find Duplicate Values in Table]

Protect Your Website Today
Home




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
Live Chat