Igor Tandetnik <[email protected]> wrote: > Black, Michael (IS) <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
