XF 1.5 SQL to modify members' usergroups

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?



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