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 : mysql
No comments for this entry yet...
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;