开发者

Help! keyword's priority in MySql fulltext search!

In my this query:

SELECT *, MATCH(keywords) AGAINST ('get back future 2 ' IN BOOLEAN MODE ) AS score FROM
movie WHERE MATCH 开发者_开发问答(keywords) AGAINST ('get back future 2 +movie' IN BOOLEAN MODE) HAVING 
score > 0 ORDER BY score DESC, in_cinema DESC 

when the record match the all keywords:' get back future 2',it return the right record.But with some partial keywords matched.such as only 'future' or '2',mysql return the record with '2' matched records in front of the records with 'future' keyword.Is it mean that mysql makes the digital number with higher priority than character or any other something.But I thought it was much better to get the records which were matched 'character keywords' first!

And I had Configured the "ft_min_word_len " to 1 for my personal usage.

thank you very much!!


Please refer link :

http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html

I hope it will help u in this query.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜