Find duplicate entries in MySQL

In : Uncategorized, Posted by admin on Mar.03, 2010

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

Tags :

 
close Reblog this comment
blog comments powered by Disqus