title: mysql fulltext search in boolean mode
body: <p>I want to search the database using mysql's fulltext index using multiple search terms:</p>
  
  <pre><code>SELECT description FROM `products` WHERE match(name, description) against('*ana* *apple*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>I want the above query to return the following records, but it wont work:</p>
  
  <pre><code>babana pie
  applet
  fried bananas
  juicy apples
  </code></pre>
  
  <p>Is my query ok?</p>