Probably basic PHPMyAdmin question

[Freebie]

Tweet

I need to find some duplicates in a database. I use PHPMyAdmin to manage the database. How do i do this.

The database has approx 30,000 entries, so sorting by field and scrolling through is not an option!

It's a single field that's duplicate, not the entire record. And there's 6 of them to be found.

Help would be much appreciated.

[ianm]

Easiest way would be to do a query similar to the following -

SELECT fieldname, count(*)
FROM tablename
GROUP BY fieldname
HAVING count(*) > 1

where fieldname is the name of the field that has the duplicates in.

That should give you the records that are duplicated.

[Freebie]

Excellent, haven't tried it yet, but i will a little later.

Thanks