mysql - 如何获取选择查询选择结果的关键字？

Question

如何在MySQL中使用全文搜索MATCH() AGAINST()获取select查询选择结果集的精确关键字

SELECT ... , MATCH(table_column) AGAINST("'LIST_OF_KEYWORDS' IN BOOLEAN MODE") AS relevance

现在我想得到完全匹配的关键字

Answer 1

来自 MySQL 文档:

Find rows that contain the exact phrase “some words” (for example, rows that contain “some words of wisdom” but not “some noise words”). Note that the “"” characters that enclose the phrase are operator characters that delimit the phrase. They are not the quotation marks that enclose the search string itself.

找到确切的短语:

SELECT * FROM your_table 
WHERE MATCH(table_column) AGAINST('"PUT_YOUR_PHRASE"' IN BOOLEAN MODE) AS relevance

至少找到一个关键字:

SELECT * FROM your_table 
WHERE MATCH(table_column) AGAINST('KEYWORD1 KEYWORD2' IN BOOLEAN MODE) AS relevance

在两个关键字处查找:

SELECT * FROM your_table 
WHERE MATCH(table_column) AGAINST('+KEYWORD1 +KEYWORD2' IN BOOLEAN MODE) AS relevance