mysql 数据表中查找重复记录

select mobile_phone,count(*) as count from lawyer group by mobile_phone having count>1;