title: PHP MySQL based search with approximate matching
body: <p>I would like to make my search feature to work more smartly in case of typo or product name special character. </p>
  
  <p>For example, we have a product with name "Post-it" and we want to show it if users type "Post it" or "Postit". <br>
  Another example, we have a product with name "bic clic stic", we want to show it if the user searches for "bic clic stick" since it has a close match.</p>
  
  <p>Our current query is like:</p>
  
  <pre><code>SELECT name, image, sku, description FROM products WHERE name like '%KEYWORD%' AND ....
  </code></pre>