You can use the following query to get all duplicated records of a MySQL table having equal values for the respective field:

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.