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 containing tokens starting with "any" (and
ending with any sequence of characters).
What if I want docids of documents containing the exact literal token "any*"?
Dave
Sent with [inky: <http://inky.com?kme=signature>]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users