[sqlite] FTS4 search for terms inside a word

I have a virtual FTS4 table and I would like to search for some terms inside a word, is that possible? For example if a column contains mysuperword mytestword I would like to find it using the subword: super. So with LIKE it worked but it is really slow: SELECT * FROM myTable WHERE myColumn

Re: [sqlite] FTS4 search for terms inside a word

Unfortunately FTS is only able to do prefix search, not sufix. -- View this message in context: http://sqlite.1065341.n5.nabble.com/FTS4-search-for-terms-inside-a-word-tp70196p70218.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] FTS4 search for terms inside a word

Marco Bambini wrote: I have a virtual FTS4 table and I would like to search for some terms inside a word, is that possible? No. For example if a column contains mysuperword mytestword I would like to find it using the subword: super. While with the MATCH operator it does not find

Re: [sqlite] FTS4 search for terms inside a word

On Jul 22, 2013, at 3:29 PM, Marco Bambini ma...@sqlabs.net wrote: I have a virtual FTS4 table and I would like to search for some terms inside a word, is that possible? Not with the default tokenizers, but perhaps you could write your own, say an ngram tokenizer or such.