must match both columns in boolean mode
I have this sql query currently:
SELECT htext FROM paragraphs WHERE MATCH(htext, keywords)
AGAINST('+genomics' IN BOOLEAN MODE) ORDER BY MATCH(htext)
AGAINST('+genomics' IN BOOLEAN MODE)desc
however I'm getting back rows if they match 开发者_Python百科in EITHER htext OR keywords...I want the keyword to have to match in htext AND keywords. Im also having issues actually ordering by relevance in mysql 5.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
精彩评论