XF 2.2 Need an SQL query to correct usergroups for a vBulletin import


Well-known member
On a rather large forum that was migrated from vBulletin, there are a few special groups that were not put in the correct primary-secondary user groups. In total, there are some 1500 users miscategorized.

For example, probably the biggest one is members of the vBulletin Banned group who were imported as primary group Banned.

Is there an SQL query that I can run to change all of these to primary group Registered and secondary group Banned?