database

How do I find duplicate records in a MySQL table?

To find duplicate records in a table, use a select statement like the one below:

select name, count(address) as count
from address_book
group by address
having count > 1
order by count;

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

To Top