Find duplicate entries in a MySQL Table
You can use the following query to get all duplicated records of a MySQL table having equal values for the respective field:
1 |
SELECT fieldname, COUNT(*) FROM tablename GROUP BY fieldname HAVING COUNT(*) > 1 |
This query will give you a list of all the entries having the same value for fieldname. It also will show the amount of duplicates.