[Antivirus]

Originally Posted by Marco van Herwaarden

I hope that you know what you are doing, as the example you provided would move ALL users with a userid smaller then 24509 (including an admin with id = 1 for example???) to this new usergroup.

Naturally, actually the query would be as follows:
[SQL]
UPDATE user
SET usergroupid = 34
WHERE userid < 24509
AND usergroupid = 2
[/SQL]

Originally Posted by Paul M

You should update the displaygroupid as well (if it's not '0' and is equal to their existing primary group).

Ok, thanks that's what i was wondering, if there were any other values that should be updated in tandem.

Thanks to both of you