title: Mysql query: match against using wildcard
body: <p>I have table named 'acts' which has 3 columns which are indexed together:</p>
  
  <pre><code>act_name, short_description, main_description
  </code></pre>
  
  <p>Within the table, one row has an act named 'red riot'</p>
  
  <p>When I execute the following search, red riot appears in the results:</p>
  
  <pre><code>SELECT * from acts where MATCH(act_name, short_description, main_description) AGAINST ('*r*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>Yet if I expand on that, and search for <code>*re*</code> it returns no results:</p>
  
  <pre><code>SELECT * from acts where MATCH(act_name, short_description, main_description) AGAINST ('*re*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>Why is that? Is there a better way to use wildcards in match against queries?</p>
  
  <p>I have tried changing <code>*</code> to <code>%</code> but this returns no results on either query.</p>