FULLTEXT Irrelevant results
Posted
by
Imran Omar Bukhsh
on Stack Overflow
See other posts from Stack Overflow
or by Imran Omar Bukhsh
Published on 2010-12-12T18:17:34Z
Indexed on
2011/01/01
1:53 UTC
Read the original article
Hit count: 162
Just came across this issue using the fulltext search of mysql.
I have like 250 records ( long articles like stuff ) and am using the fulltext MATCH AGAINST IN BOOLEAN MODE
. Now if I search for a keyword e.g. 'Samsung' and if this keyword is present in ALL the records then it returns all the 250 records which it should ( of course without `IN BOOLEAN MODE it would return nothing as the keyword is present in more than 50% of the records ).
Now the problem is that in some articles the keyword 'Samsung' occurs once and in others a couple of times, but MYSQL is giving a score of 1 to all the records returned, even those which have 'Samsung' like 15 times in them.
© Stack Overflow or respective owner