Dryice Liu’s Blog

mysql tip: finding duplicated records

Found here: http://mysql-tips.blogspot.com/2005/04/mysql-find-duplicate-repords-example.html

select address, count(address) as cnt
from mailing_list
group by address
having cnt > 1
order by cnt;