UBB.Developers Forums UBB.threads 7 Development How Do I? List users based on group

I am looking for a way to list users based on what group they are in.

Basically I want a page to like Display all Moderators (Group 2).

The problem I have is when I try to do a query into the U_Group colum in the database I can only get one to work and that would be Users since it is "-3-" and only get those users who are only in that group.

I know there is a way to do this since the forums themselves do it. I just cannot figure it out.

Could anyone help me out with the query I should run to get this to work?

(Using version 6.0.2 btw)

Moderators would also be users - so their groups would most likely look like '-2-3-'. So you can use a LIKE to grab them.

SELECT U_Username FROM w3t_Users WHERE U_Groups LIKE '%-2-%'

Although the group number doesn't determine their moderator status - you might want to query on the U_Status field.

SELECT U_Username FROM w3t_Users WHERE U_Status = 'Moderator'