title: full text multiple string search
body: <p>For a given tags column (id: 167) that is equal to "Hair Cut and Color",</p>
  
  <p>trying to figure out why the following SQL statement outputs 0:</p>
  
  <pre><code>SELECT MATCH(tags) AGAINST ('+hair* +cut*' IN BOOLEAN MODE) AS relevance FROM listings WHERE id = 167
  </code></pre>
  
  <p>Whereas the given SQL below returns 1:</p>
  
  <pre><code>SELECT MATCH(tags) AGAINST ('+hair* +cut' IN BOOLEAN MODE) AS relevance FROM listings WHERE id = 167
  </code></pre>
  
  <p>Thanks for help in advance.</p>