Re: [sqlite] Does Substr() use index?

Paul Gaspar <[EMAIL PROTECTED]> wrote: > Hello, just a short question: Does this use the index on f > > select * from t where SUBSTR(f,1,1) = 'a' > > so that it is an alternative for > > select * from t where ( f >= 'a' and f < 'b' ) > > > Thanks a lot > > Paul No, but you can read about

[sqlite] Does Substr() use index?

Hello, just a short question: Does this use the index on f select * from t where SUBSTR(f,1,1) = 'a' so that it is an alternative for select * from t where ( f >= 'a' and f < 'b' ) Thanks a lot Paul