move/copy all members of a group

[sc4t]

Hello

I'd like to find a solution to move/copy all members of a group to place in the registered users group (in the past I do the error to remove the members of this group because I thought that there was duplication)

Via a sql query can be? (If yes which?)

Thank you

[Exze]

UPDATE PREFIX_users SET `usergroup` = 'NEW_USERGROUP' WHERE `OLD_USERGROUP` = 'OLD_USERGROUP_NUMBER'

so for my forum it would be

UPDATE `mybb`.`mybb_users` SET `usergroup` = '2' WHERE `mybb_users`.`usergroup` = 1;

[sc4t]

thank you very much

[Exze]

No problem.