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
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
2 matches
Mail list logo