Re: [sqlite] Re: Re: like operator
Maybe you should look at using FTS to get indexed text searching. RaghavendraK 70574 wrote: sorry. regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - 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]> 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 EXPLAIN QUERY PLAN. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: Re: like operator
sorry. regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - 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]> 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 EXPLAIN QUERY PLAN. > > Igor Tandetnik > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
[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 question, be aware you can find out yourself by prepending your query with EXPLAIN QUERY PLAN. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: Re: like operator
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 Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -