Finding duplicates in a MYSQL table | WebTechKitchen; Your Web Technology Kitchen, contact us to create, or maintain your websites and other digital properties.

Finding duplicates in a MYSQL table

select name, count(name) as cnt
from term_data
group by name
having cnt > 1
order by cnt;