Mysql查询重复字段

查询category表中，catname字段值重复的数据及重复次数

select catname, count(*) as count 
from category 
group by catname 
having count>1