I have unsubscribe many, many times, but you have a serious problem
receiving the message. I am papa at arbolone.ca, please, please unsubscribe me.
This mailing list is useless to me, if this continues I will take more
offensive action, which is something both of us are trying to avoid.
If you are reading this email, but you are not gcc-help administrator,
please, please, forward this email to the administrator or simple reply to
all. GCC-help should know what to do with this message. Thanks in advance
and please forgive me for any inconvenience.
-----Original Message-----
From: Bernardo Sulzbach
Sent: Thursday, July 23, 2015 10:47 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Possible substr() optimization?
> select * from tbl1 where substr(col1,1,1) in ('A','a') and col1 like
> 'a_c%';
Just adding to Igor's answer:
col1 between 'a' and 'b' or col1 between 'A' and 'B'
if you need this case sensitive behavior
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
