Hello.
In our database we have a job table.
The job table has Job_No which is Auto Increment
We have a file number field (File_No) which we enter our own number aswell, but many years ago, this was done using Rapid File and the File Numbers got duplicated.
Is there a PHP or SQL script I can run to show duplicate file numbers, so we can then make this field unique to prevent this happening again?
Thanks
Paul
Its ok.
I used this
SELECT File_No, COUNT( )
FROM job
GROUP BY File_No
HAVING COUNT( ) >1
LIMIT 0 , 500