mysql - find duplicate entries in db -

i need find duplicate entries in db table. there has 1 row per table field matches id. how structure query find if field value repeated more once?

thanks.

select count(*),  field_name table_name group field_name having count(*) > 1;