Cleaning up a SQL database

Quesry for identical fields

[bateman_ap]

Hi, I have a database of around 20,000 widgets. Now I know it has a few dupes in there and want to basically run a SQL query which if it finds the same name more than one returns it as a result so I can check the Query for dupes.

So the result would be something like:
Blue Widgetie
Blue Widgetie
Blue Widgetie
Red Widget
Red Widget

Can't believe I can't find some help on this searching around or I might just be using the wrong keywords.

[coopster]

Maybe this thread will give you some ideas ...
[webmasterworld.com...]

[bateman_ap]

Cheers coopster, that looks like what I need. Time to play methinks.

[mattglet]

SELECT COUNT(column_to_check) as dupe_count FROM your_table
GROUP BY column_to_check
ORDER BY dupe_count DESC

That will put some numbers next to your results.