Bitwise operator in SQLAlchemy

Question

How would I write the following SQL query in SQLAlchemy involving a bitwise and?

select * from table where flags & 1 = 1;

Where table is the table name, and flags is the column name in that table.

Kevin Burke · Accepted Answer · 2012-07-21 22:21:07Z

31

You want to use the bitwise operator like this:

session.query(User).filter(somecolumn.op('&')(1) == 1)

You can write something similar for OR:

session.query(User).filter(somecolumn.op('|')(4) > 4)

answered Jul 21, 2012 at 22:21

Kevin Burke

65.6k83 gold badges203 silver badges328 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1