I am using the following SQL statement for SQLite:
select * from words where "word" like ? || '%' || ? ;
In order to bind parameters to the first and last letters. I have tested
this both with and without an index on the column `word`, and the results
are the same. However, when running the queries as
select * from words where "word" like 'a%a';
etc. (that is, hardcoding each value instead of using ||, the query is about
x10 faster when indexed.
Can someone show me how to use both the index and the parameters?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
