[SOLVED] mysql count help and duplicate rows

[acidglitter]

this is probably really simple but i can't seem to figure out how to do this. i'm trying to switch primary keys and get rid of duplicate rows in one of my tables. whats an easy way to do this?

 

i tried something like this..

SELECT id FROM members WHERE COUNT('id') > 1

but that didn't want to work..

[Barand]

SELECT id, COUNT(*) as total

FROM members

GROUP BY id

HAVING total > 1

ORDER BY total DESC