Help! keyword's priority in MySql fulltext search!

Question

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!!

Answer 1

Please refer link :

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

I hope it will help u in this query.