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
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;
Add New Comment
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Add New Comment