title: mysql partial word searching
body: <p>I want to search like the below query but it is not working in MySQL</p>
  
  <pre><code> SELECT * FROM products WHERE MATCH (title,description) 
   AGAINST ('test' IN BOOLEAN MODE); 
  </code></pre>
  
  <p>I want below output</p>
  
  <blockquote>
    <p>testproduct, producttest</p>
  </blockquote>
  
  <p>Can anybody help me on this..?</p>