So while trying to find a solution to my problem of finding partial strings in several columns ( finding 'this' in 'HellothisIsATest' using MATCH '*this*' ), I found out that sqlite fts3 only supports prefix matching and that if I want to do partial string matching, I would be forced to use LIKE, or create my own tokenizer in order to index my terms the way I want. I wouldn't mind sacraficing size for performance since I do not have a size constraint for my project.
My question is, has anyone already written a tokenizer that would do what I want? It seems as if this problem should have already been solved for me, and I really don't want to reinvent the wheel if it already has been done :) Thanks, Jon On Thu, Oct 9, 2008 at 9:51 PM, Jonathon <[EMAIL PROTECTED]> wrote: > 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