SQL query to mass add members to another group?

[PhilMcKrackon]

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,

[sunilvarma]

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.

[Marco van Herwaarden]

or just move them from the AdminCP.

[PhilMcKrackon]

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. ??

[Marco van Herwaarden]

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