SQLite Forum

A suboptimal solution - not using the index.
Login
Only if you do not have a field named "1" in the scope of the SELECT statement.

Single quotes for text literals, double quotes for "funny" field names.