必须在布尔模式下同时匹配两列

Question

我现在有一个sql查询：

SELECT htext FROM paragraphs WHERE MATCH(htext, keywords)
AGAINST('+genomics' IN BOOLEAN MODE) ORDER BY MATCH(htext)
AGAINST('+genomics' IN BOOLEAN MODE)desc

但是，如果行在htext或关键字中匹配，我将返回这些行……我希望关键字必须在htext和关键字中匹配。在MySQL5.1中，我也遇到了按相关性排序的问题

Answer 1

SELECT htext,  MATCH(htext) AGAINST('+genomics' IN BOOLEAN MODE) AS Relevance FROM paragraphs 
WHERE MATCH(htext) AGAINST('+genomics' IN BOOLEAN MODE) 
AND MATCH(keywords) AGAINST('+genomics' IN BOOLEAN MODE)
ORDER BY Relevance DESC