Igor Tandetnik <itandet...@mvps.org> wrote: > Black, Michael (IS) <michael.bla...@ngc.com> wrote: >> Any particular reason you can't build your own string and just pass one >> parameter? >> >> select * from words where "word" like ?; > > That won't help - SQLite still can't use the index.
I take this back. From http://sqlite.org/optoverview.html section 4: "The right-hand side of the LIKE or GLOB must be either a string literal or a parameter bound to a string literal that does not begin with a wildcard character." So it's at least possible to use the index here, if all other conditions also hold. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
