From my earlier post:

If you know the group id, then you can verify with the following query (just change # to the actual group id):

SQL Query
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'

You'll want to at least have MySQL 4.0, but 4.1+ is preferred.