:00 pm
Subject: [sqlite] Re: Re: like operator
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Will Sqlite uses indexes when
using the like operator
as below,
select * from tbl where '9845' like column || '%'
order by des limit 1;
No. Next time you have a similar ques
!
*
- Original Message -
From: Igor Tandetnik <[EMAIL PROTECTED]>
Date: Sunday, August 26, 2007 7:00 pm
Subject: [sqlite] Re: Re: like operator
> RaghavendraK 70574
> <[EMAIL PROTECTED]>
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
Will Sqlite uses indexes when
using the like operator
as below,
select * from tbl where '9845' like column || '%'
order by des limit 1;
No. Next time you have a similar question, be aware you can find out
yourself by prepending your query with EXP
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
I could not under the "/" what is the purpose of it?
Like I said - '/' just happens to immediately follow '.' in ASCII table.
Thus, 'xxx/' is the smallest string greater than any string of the form
'xxx.yyy', in lexicographical order.
Igor Tande
4 matches
Mail list logo
