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.
精彩评论