SQLite Forum

ESCAPE '%'
Login
The SQL statement is "SELECT id ..." so the {4} and {2} are the lists of id returned.

And there is (and should only be) one row returned by each query.

Why do you think the number of rows returned for each query should be two?