title: Search multiple table fields with one string, broken apart (MySQL)
body: <p>I have a simple search feature that will search a table for a hit. Basically the one flaw of this search is that it tries to match exactly the string. I want it to take a string of say "large red bird" and search "large", "red" and "bird" separately against the table. here's my search query...</p>
  
  <pre><code>$result = mysql_query("SELECT * FROM files
           WHERE (tags LIKE '%$search_ar%' OR
           name LIKE '%$search_ar%' OR
           company LIKE '%$search_ar%' OR
           brand LIKE '%$search_ar%')
           $str_thera $str_global $str_branded $str_medium $str_files");
  </code></pre>
  
  <p>any Ideas? thanks</p>
  
  <p><strong>Edit</strong>
  OK here's my updated query but it doesnt return anything.</p>
  
  <pre><code>$result = mysql_query("SELECT * FROM files
             WHERE MATCH(tags, name, company, brand)
             AGAINST ('$seach_ar' IN boolean MODE)"); 
  </code></pre>