title: MySQL full-text search result relevancy
body: <p>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:</p>
  
  <pre><code>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;
  </code></pre>
  
  <p>The results i get are shown in the image below:</p>
  
  <p><img src="https://i.stack.imgur.com/5xHLy.png" alt="Search Result"></p>
  
  <p><strong>What i expect is the second result to come up on top as it is the exact match, but it doesn't</strong>. Can somebody please correct me on what i might be doing wrong here.</p>
  
  <p>Thanks.</p>
  
  <p><strong>Edit</strong> Results in boolean mode
  <img src="https://i.stack.imgur.com/dsIG6.png" alt="Results in boolean mode"></p>