querry help

[drives fast]

hello......before comming to my senses and creating usergroups to deal with my forum permissions I used to use access masks.....well...I have a private forum and I thought I saw a member in there that wasn't on my list as having access and I think I may have a "left-over" access mask somewhere in my almost 15,000 member database. I didn't get the name written down before they were gone and couldn't remember what it was.

okay...on to the question......could I run a querry in phpmyadmin to look for a specific access mask?

Like in the user table to look for forumid100=yes or something like that?

If the answer is "yes" then could someone also show me the querry to run? I am not good enough to know what to do

[drives fast]

here is the querry that looks for the "inforum".... SELECT * FROM `user` ORDER BY `inforum` ASC LIMIT 0, 30

How can I modify this to look for a member that has access to forumid 101 only?

[Logician]

I guess you should concentrate on "access" table. What does
select * from access where forumid=X
returns? (X is your private forumid)

[drives fast]

that was it...thank you very much