开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜