Please wait while we load your page...


Latest Version [8.00202307241] Last Updated [Jul-24-2023]

PasswordSentry Highly Recommends NETbilling

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
Blog Posts

Random Security Blog Articles

See All Blog Posts

PasswordSentry :: Security Blog ArticleFloods of traffic can clog up an internet server and the wires connecting it to other systems. BeeBright/ Scott Shackelford, Indiana University Back in November 1988, Robert Tappan Morris, son of the famous cryptographer Robert Morris Sr., was … Read More
PasswordSentry :: Security Blog ArticlePormezz/Shutterstock Chaminda Hewage, Cardiff Metropolitan University The biggest known biometric data breach to date was reported recently when researchers managed to access a 23-gigabyte database of more than 27.8m records including fingerprint and facial recognition data. The researchers, working … Read More