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]
-----------------------------------------------------------------------------