Is there any SQL query by which I can put all the members of a group to another group?
Why can't you just modify the existing group however you want, then make a new group for whatever you need it for?
I just want to know the sql query..its useful sometimes..
Make sure you take a database backup before you execute this in case I have failed to take a relationship within the database into account but:
UPDATE mybb_users SET usergroup = newgroupid WHERE usergroup = oldgroupid;