Re: [sqlite] Escaping conventions for FTS4 virtual table queries

2014-03-18 Thread Clemens Ladisch
Dave Baggett wrote: > What if I want docids of documents containing the exact literal token "any*"? You would have to use one of the Unicode tokenizers, and configure it to interpret * as a token character. > how do I escape the asterisk so that it's not interpreted as a wildcard? There are no

[sqlite] Escaping conventions for FTS4 virtual table queries

2014-03-17 Thread Dave Baggett
This may seem rather esoteric, but if I want to find all FTS matches for a literal string containing an asterisk, how do I escape the asterisk so that it's not interpreted as a wildcard? Specifically, this query: SELECT docid FROM fts WHERE text MATCH 'any*'; will give me docids of documents