title: MySQL MATH AGAINST returns a score of 0
body: <p>I've got this table called <code>Names</code>:</p>
  
  <pre><code>ID | name
  -----------------
  1 | nobody
  2 | brian
  3 | john
  4 | greg 
  </code></pre>
  
  <p>I've altered the table as such:</p>
  
  <pre><code>ALTER TABLE Names ADD FULLTEXT index_name(name);
  </code></pre>
  
  <p>When I execute this query:</p>
  
  <pre><code>SELECT *, (MATCH (name) AGAINST ('brian')) As score FROM Names;
  </code></pre>
  
  <p>I get the following result:</p>
  
  <pre><code>1 | nobody | 0
  2 | brian | 1.0861...
  3 | john | 0
  4 | greg | 0 
  </code></pre>
  
  <p>But when I do this:</p>
  
  <pre><code>SELECT *, (MATCH (name) AGAINST ('bria')) As score FROM Name;
  </code></pre>
  
  <p>Or</p>
  
  <pre><code>SELECT *, (MATCH (name) AGAINST ('bria*')) As score FROM Name;
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>1 | nobody | 0
  2 | brian | 0
  3 | john | 0
  4 | greg | 0 
  </code></pre>
  
  <p><code>brian</code> is not in more than 50% of my queries and is certain not a stopword, so not sure what's going on.</p>