XF 1.5 SQL to modify members' usergroups

[Khalid]

I want SQL statement that I can execute using PHPMyAdmin (Cpanel) which can modify the usergroups setting for some members at once.

The SQL should modify usergroups of users whose their primary usergroup is (name: Special, group id: 23) TO Primary usergroup (Registered, ID: 2) and secondary usergroup (Special).

Can someone please help me with this SQL statement?

Thanks

 

[Mike]

The short answer is that you can't do this via SQL. There are a lot of things that need to be updated/recalculated.

 

[Khalid]

Thanks Mike.
I have to do more than 300 users manually!

 

[Khalid]

I found the solution!
There is a "Batch Update Users" function in AdminCP which exactly does what I want.