MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Sander Pilon Date:September 10 2000 6:21pm
Subject:Fulltext - order weirdness
View as plain text  
So, I have a set of articles.

I do a query like this:

select *, match( body ) against ('court order') as m from article_bodies_42
where match( body ) against ('court order') limit 10;

It returns a set of results like this: (MATCH Value, String)


15.007   ... order ...
10.777   .... court ... order .....

Why is a article with just one word of the query above one with both words?

You'd assume that an article with both words in it ranks higher than an
article with just one word, and that an article with both words in-order
ranks higher than an article with both words far apart.

-Sander





Thread
Nice words for/questions about FULLTEXT searchRob McMillin10 Sep
  • RE: Nice words for/questions about FULLTEXT searchSander Pilon10 Sep
  • RE: Nice words for/questions about FULLTEXT searchSander Pilon10 Sep
    • Fulltext - order weirdnessSander Pilon10 Sep
      • Re: Fulltext - order weirdnessSergei Golubchik11 Sep