SQL query to mass add members to another group?
 

I need to add all my registered members to another user group.

Lets say I want to add all registered members to the Premium user group. Can anyone help me with the query that would do this?

Regards,

I don't have an SQL query for this but I know a way to do this.

Create a promotion in the ACP - users in registered usergroup with posts greater than 0 to be added to the premium usergroup.

Then, go in to scheduled tasks and run the promotions scheduled tasks.

or just move them from the AdminCP.

Never thought about using promotions. Thanks,

Marco, I don't want to move them, just add them to another group. I don't see her this can be done by the AdminCP. ??

No if you want to add a secondary usergroup to all these accounts, then a promotion is the easiest.