Mysql查询某字段值重复的数据

查询tablename表中，field字段值重复的数据及重复次数

select field,count(*) as count from tablename group by field having count>1;