On Fri, Aug 6, 2010 at 11:32 AM, Scott Hess <sh...@google.com> wrote: > On Thu, Aug 5, 2010 at 12:42 PM, Sam Roberts <vieuxt...@gmail.com> wrote: >> FTS3 only searches full terms/words by default, but I think if I built a >> custom >> tokenizer that returned all the suffix trees for a name: > > FTS3 can do prefix searches, MATCH 'a*'. Also, it aimed to support
Prefix searches don't allow matching in the middle of words. For example, I want "bert" to match my name, "roberts". So, I think I'd need to tokenize roberts as "s", "ts", ..., "berts", "oberts", ... etc. Then do a prefix match for "bert*" in order to see that "roberts" matches. Lucky, I don't need or care about any of the snippeting stuff, because I'm matching short strings (names). Cheers, Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users