title: MYsql FULLTEXT query yields unexpected ranking; why?
body: <p>i'm trying fulltext search with tags but it doesn't works properly for me chek attached image please<img src="https://i.stack.imgur.com/S0pmf.png" alt="enter image description here"></p>
  
  <p>The query is:</p>
  
  <pre><code> SELECT *, 
           MATCH(tags) AGAINST ('tag3 tag6 tag4') AS score 
      FROM items
  ORDER BY score DESC
  </code></pre>
  
  <p>why does the score is not ordering in the right order fields? if you check the second row has all the tags i searched while the first field does not have tag3 keyword .</p>
  
  <p>i mean id fields order should be : 5,1,2 .. etc and NOT 1,5,2..etc </p>
  
  <p>where is my mistake?</p>
  
  <p>then i would like to search first in tags field then if no results i would like to search the same keyword as FULLTEXT inside description field, so users will search both in tags and description if tags does not match , is it possible in the same query or i need two separated queries?</p>