MyBB Community Forums

Full Version: Need a query to move some user to another group
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I need to generate a query to run it in PHPMyadmin and move all user inside group 10 and have less than 3 post to group 11.

can anyone help me?

is it true?
UPDATE `mybb_users` SET `usergroup`=11 where `usergroup`=10 and `postnum`<3
UPDATE `mybb_users` SET `usergroup` = '11' WHERE `usergroup` = '10' AND `postnum` < '3';