title: Search table for keyword
body: <p>I have a website that basicly consists on a video search engine, I have the follow code that will query mysql for the given input criteria:</p>
  
  <pre><code>$search=htmlspecialchars($_GET['load']); 
  $say=mysql_query("SELECT * FROM madvideo WHERE MATCH (baslik) AGAINST ('*$search*' IN BOOLEAN MODE)"); 
  </code></pre>
  
  <p>Then I have the follow code that will display the results:</p>
  
  <pre><code>     $katala=mysql_query("SELECT * FROM madvideo WHERE MATCH (baslik) AGAINST ('*$search*' IN BOOLEAN MODE) order by id asc limit $s,$perpage");
              $i=0;
                      while ($sea=mysql_fetch_array($katala))  { 
              $i++;
  
  $idd=$sea['id']; $seoo=$sea['seo']; $baslikk=$sea['baslik']; $resimm=$sea['resim']; $suree=$sea['sure'];
   $izlenmee=$sea['izlenme']; $tarihh=$sea['tarih']; $katt=$sea['kat'];
  </code></pre>
  
  <p>Let me try to explain what's the problem with this.
  Lets say you search on my website for "I like to eat strawberry"</p>
  
  <p>And lets suppose I have on mysql table an entry with the very same name "I like to eat strawberry"</p>
  
  <p>With my current code I will get the follow example results:</p>
  
  <p>"I like to drive my car"
  "my car is super fast"
  "they eat to much"
  and so on, and the relevant result might appear but not at first like I would like to be.</p>
  
  <p>How can I make it display the results in a more relevant way, like the google for example? </p>