How do i Find Duplicate Data

[surplustronics]

Hi
MySQL database is wonderfull! and it basically runs our whole company.

I need to know how to find Duplicate entries in a database field, because in this case its the Row ID (was auto increment) and somehow (my webmaster tells me) it has duplicate entries in that field.

With a little over 4000 products in the database at hand, i don't want to find them manually!

help!

[vladimir_cz]

select id, count(id) as idc from products group by id order by idc desc - you got a list with two columns, 1st - ID, 2nd - counter for ID (duplicates)