title: How to search database like google in php
body: <p>Hi I want to implement my own search feature into my website and I want to show results to user in all possible ways.</p>
  
  <p>I'm currently using this Query </p>
  
  <pre><code>$rs = $conn-&gt;query("SELECT * FROM search_engine WHERE soundex(keyword) LIKE soundex('%$q%') UNION SELECT * FROM search_engine WHERE title LIKE '%$q%' OR link LIKE '%$q%' ORDER BY `clicks` DESC");
  </code></pre>
  
  <p>I know that this query is not good.
  This query only showing results when parameters match to the title, Keywords or link 
  e.g. when I search for <code>Extract all url from sitemap.xml with PHP CURL</code> query, I'm getting results but when I try this query <code>How to Extract all url from sitemap.xml with PHP CURL</code> I can't getting any result, so what can I do to make my search feature powerful.</p>