Hello, how can I query a FTS3 table for all records NOT containing a specific string? Something like
SELECT * FROM docs WHERE docs MATCH 'NOT sqlite'; gives the error "malformed MATCH expression". More generally, I want to translate a boolean function (using &&, || and the unary negation !) to a FTS match query. What would the FTS query for "aaa || !bbb" be? Thank you for any help. Best regards, Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users