[1.2.4] Bitwise operator in JPA

[Philip Camilleri]

hi All,

I'd like to run a very simple using a bitwise where-clause -- e.g. "SELECT something FROM table WHERE (field & 3) = 3"

This is easily done with MySQL, but JPA absolutely doesn't allow "&" in the query. I've been digging around trying to hack away at this, but I keep hitting dead ends.

Any suggestions on how to implement this (for play 1.2.x)?

thanks!
Phil.

[eee]

Ignoring why you would do that...

You will have to use modulo and divisions by 2^n
For your example you could do

field % 4 = 3