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

Reply via email to