I am wondering if there is an easy way to change 3600 odd users from there user ID's
The list in the user table is running out of sequence, and I would like the userid's to run from 1-3600 in sequence, but instead the run like 1,2,4,6,8 from inactive members that have been deleted.
Is there any easy way to do this other than editing them all manually which I worked out will take hours
This is so I can merge them with another table
Cheers
Watson