Find duplicate entries in MySQL

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

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

Tags :
No comments for this entry yet...