title: PHP 'smart' search engine to search Mysql tables advice
body: <p>I am creating a search engine for my php based website. I need to search a mysql table.</p>
  
  <p>Thing is, the search engine must be pretty 'smart', so that users can easily find their items (it's a classifieds website).</p>
  
  <p>I have currently set up a FULLTEXT search with this piece of code:</p>
  
  <pre><code>    MATCH (headline) AGAINST ($querystring)
  </code></pre>
  
  <p>But this isn't enough...</p>
  
  <p>For instance, lets say the field <code>headline</code> contains something like <code>Bmw 330ci</code>.
  If I search for <code>330</code>, I wont get any results. The ending ('ci') is just one of many endings in car models which must be taken into account when searching the table.</p>
  
  <p>Or what if the <code>headline</code> field is <code>bmw330</code>? Also no results, because it only matches full words.</p>
  
  <p>Or also, what if the <code>headline</code> is <code>bmw 330</code>, and I search for <code>bmw 520</code>, still with FULLTEXT I will get the <code>bmw 330</code> as a result, even though I searched for <code>bmw 520</code>... Not good!</p>
  
  <p>How should I solve this problem?</p>