mysql全文搜索 "all but"查询

Question

我需要在表中查询“all but keyword”。只使用“-”是行不通的，事实上 mysql manual说:

Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.”

我找到的唯一解决方法是“a* b* .... y* z* -keyword”，因为这允许匹配所有其他结果。还有其他(更清洁的)方法吗？

Answer 1

只需使用:

NOT MATCH(field) AGAINST(keyword)