[sqlite] Performance issue in using 'LIKE' with Indexes.

Hi, I am a new user to sqlite3, I have a program that searches through a database. I have a table with 1 column as varchar and I want to perform a search on it. I have created an index over that column. And I use a select query with "column_name LIKE 'a%' ". So my first question is will this query

[sqlite] using sqlite for searching

Hi, I am using sqlite3 for my search application and i want an optimized way for retrieving values from table. I need a way in which I can query records from the result of previous query based on next search character. so for example If i search for words starting with "a" then if user enters "b"