On 2/18/08, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > I am trying to use FTS3 with SQlite3 . Do I need to recompile SQlite3 > to enable FTS3?
yes. > > From the command prompt I tried the following things > > Sqlite> .load libfts3.dll > Unable to open shared library libfts3.dll > Sqlite>select load_extension('libfts3.dll'); > Sql error:unable to open shared library libfts3.dll > > So my question is The FTS3 module is available in SQLite version 3.5.6 > and later? > > Thanks, > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: Monday, February 18, 2008 9:50 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite Like Query Optimization > > 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 > _______________________________________________ > 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