Hi, guys,

I have a user object which has a bit-stored privacy attribute.
When I justify whether a user has a proper privacy I could use 'user.privacy& SOME_PRIVACY '.
So I can get all the user has the privacy 16 in mysql database by 'SELECT * FROM user where privacy&16 <>0', My Question is how could I do the same thing in HQL form.

Pass in the log base 2 (so for 16, you'd pass in 4, for 1024, pass in 10), then use "mod(user.privacy / :LOG_PRIVACY ) = 1".