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"???