> could the next query use the tsamov_code index ??: > select * from tsamov where tsamov_code like 'AFG%'
Only after pragma case_sensitive_like = true; Read more about it here: http://www.sqlite.org/optoverview.html#like_opt. Pavel On Thu, Jul 14, 2011 at 11:56 AM, Sebastian Bermudez <sebastian.bermu...@yahoo.com> wrote: > simple question: > > > i have table tsamov > > create table tsamov ( > tsamov_id integer not null primary key > ,tsamov_descri text, > ,tsamov_code text ) > > i have index on tsamov_code (it's varchar column of lenght=5) > > could the next query use the tsamov_code index ??: > > select * from tsamov where tsamov_code like 'AFG%' > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users