How do I find duplicate records in a MySQL table?

Share

Tweet

Share

Share

Email

Comments

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;