How to move all the users from one group to another?

You can move users one by one between groups, but what if you want to move all the users from one group to another?

You can save the clicks!

 

It is possible via SQL using this command:

UPDATE groups_users SET group_id = [new_group_id] WHERE group_id = [old_group_id];

 

Eaxmple: UPDATE groups_users SET group_id = 10 WHERE group_id = 20; - Will move all users from the group with ID 20 to the group with ID 10

 

!Make sure that the ID you are moving the users to exists. If you move users to a nonexistent ID it can cause errors.!