Re: [sqlite] Quick FTS3 question: partial matches

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,

Re: [sqlite] Quick FTS3 question: partial matches

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

[sqlite] Quick FTS3 question: partial matches

Hello all, I've looked through the archived mailing list and although I am sure my question is common, for some reason, I couldn't find an answer. 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,