Finding Duplicates

[Antnee]

Is it possible to run a MySQL query that will just find any rows that have the same value as another? Or even to find any where one particular field's value appears more than once in the table?

Not sure how clear I'm being, so I'll try to explain myself, just in case. Lets assume that the table has allowed duplicate job numbers in a table, and I want to find them all, rather than a particular job number, can I run a query that says something like "SELECT * FROM table WHERE num_rows(job) > 1"???

Thanks for the help

[guido2004]

SELECT jobnumber, COUNT(*)
FROM table
GROUP BY jobnumber
HAVING COUNT(*) > 1

[Antnee]

Perfect, thanks loads