Splitting up banned users.

[MagicPID]

My forum has been private for a very long time and we are going to open registration back up soon. We used too ban people if they were inactive, so we would do a mass move into an inactive usergroup.

We ran into some forum trouble and in the end it has resulted in our inactive users and our actually banned users being in the same usergroup; Banned. The banned people have ban reasons if you click on their profiles but the inactive do not, is there a way maybe with an sql query to move everyone with a ban reason into another group?

Thanks