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