Thanks, I wasn't aware.
On Thu, Jul 23, 2015 at 4:21 PM, Igor Tandetnik <igor at tandetnik.org> wrote: > On 7/23/2015 10:17 AM, Staffan Tylen wrote: > >> Please consider this: >> >> create table tbl1 (col1 text primary key); >> insert ... >> select * from tbl1 where substr(col1,1,1)='a'; >> > > Make it > > WHERE col1>='a' and col1 < 'b' > > This should use the index. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
