title: MySQL FULLTEXT not matching string with wildcard
body: <p>I'm trying to do a basic full text search on my MySQL database - here's the table I'm using:</p>
  
  <p><strong>tables removed</strong></p>
  
  <p>Any input would be appreciated, as I've not used full text searching before (or indexing for that matter!)</p>
  
  <p>Thanks</p>
  
  <p>EDIT:</p>
  
  <p>I've chosen to use <code>FULLTEXT</code> because of the supposed slowness of <code>LIKE</code> searches - there will be a whole lot of these running, as it's for a javascript autocomplete type thing. Is using <code>LIKE</code> is a viable option for this? I have been advised against it. (I bring this up because all of the answers have said to use <code>LIKE</code> rather than addressing my actual question)</p>