Topic awaiting preservation: MySQL/PHP finding duplicates in table (Page 1 of 1)

Greets!

I'm looking for a way to find duplicates in a db table. Let's say I have a zillion records, and want to find any records with duplicate 'name'. How is this accomplished? I know I can do a "select * from myTable where name = 'blah'", but that's manually looking for specific records. I want to spit out all records where a field appears more than once. I hope that makes sense.

Couldn't you use GROUP BY to accomplish this?

Use a COUNT to identify multiple occurances, and only use those where count > 1?

Indeed, DL is on the right road.

You'll need to use having to select on the grouped columns though...
like

select count (id) as cnt  from myTable GROUP by name HAVING cnt > 1

so long,

->Tyberius Prime

Ah - that's cool. Much appreciated!

Boy could I have used something like that about 2 months ago.

It sounds so simple when TP says it, but I sure didn't come up with that solution.

- Butcher -

SELECT DISTINCT might also help compile an index of which rows you want to keep, though admittedly TP hit that nail pretty well already.

Just a thought,
DC