title: Mysql match...against vs. simple like "%term%"
body: <p>What's wrong with:</p>
  
  <pre><code>$term = $_POST['search'];
  
  function buildQuery($exploded,$count,$query)
  {
     if(count($exploded)&gt;$count) 
     {
        $query.= ' AND column LIKE "%'. $exploded[$count] .'%"';
        return buildQuery($exploded,$count+1,$query);
     }
     return $query;
  }
  
  $exploded = explode(' ',$term);
  $query = buildQuery($exploded,1,
  'SELECT * FROM table WHERE column LIKE "%'. $exploded[0] .'%"');
  </code></pre>
  
  <p>and then query the db to retrieve the results in a certain order, instead of using the myIsam-only sql match...against?</p>
  
  <p>Would it dawdle performance dramatically?</p>