Moving secondary group to primary

[rinkrat]

I have a group called Subscribed and I want to move all users who have this as their secondary group to have it as their primary group instead. Is there a place in AdminCP to do this or can someone tell me what mysql query to run? I don't want to have to do it by hand one record at a time!

[deathemperor]

ACP -> Users -> Prune / Move users

[rinkrat]

Nope, doesn't do the trick. You can move from one group to another but not from secondary to primary.