On 2/18/08, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > > Suppose User typed 'test' in search text box, I would like to search the > 'test' string in all the coulmns ... I do not want exact match.. The > columns could contain strings like 'tester' or 'tested' . I should be > able to get these records as well.. > > Hope I am clear explaining what I want..
you definitely should look into implementing full-text search using fts3. It will solve your problems as well as world peace. > > -Thanks > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of BareFeet > Sent: Friday, February 15, 2008 4:38 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite Like Query Optimization > > Hi Kalyani, > > > select ID from TableA where column2 like '%test%' or column4like > > '%test%' or column5 like '%test%' or column6 like '%test%' or column7 > > like '%test%' or column8 like '%test%' order by column3 desc; > > As already stated, the like operator can't use indexes if you use "or", > or start with a wild card. > > Is each '%test%' in your example meant to be the same string, or > different strings? If different, then what exactly is each column > storing, and what are you trying to search for? Perhaps you could make > each column more "atomic" by splitting the contents into more columns, > which you could then search using "=" instead of "like" and so use > indexes. > > Tom > BareFeet > > -- > One stop Australian on-line shop for Macs and accessories > http://www.tandb.com.au/forsale/?ml > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users