title: PHP SQL SELECT where like search item with multiple words
body: <p>I have a select where like query for a seach form which is as follows:</p>
  
  <pre><code>&lt;?php 
  $bucketsearch = sanitizeone($_POST["bucketsearch"], "plain");
  $bucketsearch = strip_word_html($bucketsearch);
  ?&gt;
  
   if(isset($_POST['search'])){
                    $result=MYSQL_QUERY( "SELECT * FROM buckets where bucketname like '%$bucketsearch%' order by bucketname");
                }else{
                $result=MYSQL_QUERY( "SELECT * FROM buckets order by bucketname");
            }
  </code></pre>
  
  <p>My problem is that if someone searches for instance for "apple and pear" i do not get any results that contain any of the words, i can only make it return results (well 1 result) with all the words in it. </p>
  
  <p>Can anyone help me make this search a bit more versitle?? 
  Thanks in advance. </p>