Dupilcated entries

[scialom]

Hi,

I am looking to find duplicated entries in my table. How can I do it?

Thank,
Assaf

[devinemke]

SELECT COUNT(*) AS repetitions, field FROM table GROUP BY field HAVING repetitions > 1

table = the name of the table
field = the field that are checking for duplicates

[acrabadabra]

Mysql commands: GROUP and COUNT() will do the trick.

[Sxooter]

Something like:

select count(*), field1,field2,field3, fieldlast from table group by (field1, field2, field3, fieldlast);