MySQL full-text search result relevancy

Question

I am trying to search my table for some mobile phones and am trying to get the results via Full-text search. My query is:

SELECT id,itemid,title,MATCH(title) AGAINST 
    ("SAMSUNG GALAXY S3" IN NATURAL LANGUAGE MODE) as score 
    FROM `deals`WHERE MATCH(title) AGAINST 
    ("SAMSUNG GALAXY S3" IN NATURAL LANGUAGE MODE) ORDER BY score desc;

The results i get are shown in the image below:

Search Result

What i expect is the second result to come up on top as it is the exact match, but it doesn't. Can somebody please correct me on what i might be doing wrong here.

Thanks.

Edit Results in boolean mode

What is the result IN BOOLEAN MODE ?

bpgergo
– bpgergo

2012-06-18 10:28:35 +00:00
Commented Jun 18, 2012 at 10:28 — bpgergo
– bpgergo, Commented Jun 18, 2012 at 10:28
@bpgergo - here's the result - imgur.com/xhIbl.

web-nomad
– web-nomad

2012-06-18 10:33:44 +00:00
Commented Jun 18, 2012 at 10:33 — web-nomad
– web-nomad, Commented Jun 18, 2012 at 10:33

bpgergo · Accepted Answer · 2012-06-18 10:47:50Z

1

I'm afraid "S3" is too short token to be considered to be a word by the full text search. See relevant section of the docs (the default minimum word length is 4 characters) http://dev.mysql.com/doc/refman//5.5/en/server-system-variables.html#sysvar_ft_min_word_len

EDIT you can verify this by searching for e.g.:

"SAMSUNG GALAXY S360"

answered Jun 18, 2012 at 10:47

bpgergo

16.1k5 gold badges48 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

web-nomad Over a year ago

Yes, when i search for something like "Samsung Galaxy SIII", it works. Thanks a ton for helping me. Seems i need to find a way to address these kind of searches. Thanks a lot!

bpgergo Over a year ago

I think you can set 2 in ft_min_word_len, that should work for ""SAMSUNG GALAXY S3"

web-nomad Over a year ago

In that case i will have to rebuild the index, will check if this helps.

Collectives™ on Stack Overflow

MySQL full-text search result relevancy

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related