[sqlite] Possible substr() optimization?

[Igor Tandetnik]

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