Thanks for the reply. I was just curious if anyone has found a viable workaround for this issue? Using the dreaded "Like" is a bit too slow for what I need.
Jon On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: > > I would like to look up partial strings across several columns using FTS3 > > and MATCH. For example, if I have a column that has data, > > 'helloThisIsATest'... and I do: > > > > select * from myTable where myTable match '*This*'; > > You can only use wildcards as a suffix - this is due to the nature of > the indexes fts3 uses. > > I don't know of a possible workaround for this while still using fts3. > I'd say that for this kind of request, you are condemned to use '... > like "%This%". > > Alex. > _______________________________________________ > 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
