title: MySQL FULLTEXT search returns only exact match
body: <p>I added a FULLTEXT index to a table like so:</p>
  
  <pre><code>ALTER TABLE TEST ADD FULLTEXT(name, descrip, notes);
  </code></pre>
  
  <p>The TEST table has 100 rows. I updated the <code>descrip</code> column with 'branch' in one row and 'Branches' in another row. </p>
  
  <p>Then I run</p>
  
  <pre><code>SELECT * FROM TEST WHERE MATCH(name, descrip, notes) AGAINST ('branch' IN BOOLEAN MODE);
  </code></pre>
  
  <p>The result returned only rows that contain 'branch'. 'Branches' is not included in the result, even though it is comprised of the word that was searched. How to include 'Branches'? I want to avoid using <code>LIKE</code>.</p>