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

[Kurt Welgehausen]

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 like and glob here:

  .

Regards

[sqlite] Does Substr() use index?

[Paul Gaspar]

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