mysql中获得数据字段名字相同的字段及数量

SELECT cname,COUNT(cname) AS COUNT 
FROM ly_xcly 
WHERE region = '130630' 
GROUP BY cname HAVING COUNT(cname) >1
ORDER BY COUNT DESC;