subject:"\[sqlite\] using sqlite for searching"

Re: [sqlite] using sqlite for searching

2009-02-13 Thread Kees Nuyt

On Fri, 13 Feb 2009 16:06:42 +0530, aalap shah wrote in General Discussion of SQLite Database : >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

Re: [sqlite] using sqlite for searching

2009-02-13 Thread P Kishor

On Fri, Feb 13, 2009 at 4:36 AM, aalap shah wrote: > 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

[sqlite] using sqlite for searching

2009-02-13 Thread aalap shah

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"