How do I use a boolean field in a where clause in SQLite?
You don’t need to use any comparison operator in order to compare a boolean value in your where clause. If your ‘boolean’ column is named is_selectable, your where clause would simply be: WHERE is_selectable