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):
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'
You'll want to at least have MySQL 4.0, but 4.1+ is preferred.