Bit compare on a set

[tibberous]

I have a MySQL set. I could query it as a string and do string compare, but I'd kind of rather get it as an i and do bit comparision.

 

So... how do I do that?

 

I know:

 

select `permissions`+0

 

Will give me the decimal value of the set. How can I check to see if a bit is on or off though?

[Christian F.]

Haven't tried this, but it should work:

SELECT `permissions` & $Bit

 

Where $Bit is the bit value you want to test for.