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. > And any reason why you don't create a 2nd field holds the 1st and last char? > and index that? Then your query should be blazingly > fast as it will actually use the index (which I don't believe LIKE uses at > all). It may, under certain limited circumstances. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
