SQLite Forum

SQLite doesn't use indexes for bitwise clauses?
Login
If it's an integer you could work out that x will be between a and b yourself and include that condition in the where such that the index will be used.