title: Mysql multiple LIKE not working
body: <p>I have a stores table. Some fields are name,website,description,etc.</p>
  
  <p>I have an autosuggest search bar. I want to match input and display some related stores. Right now it works perfectly matching user input with a LIKE statement for name.</p>
  
  <pre><code>$input = $_GET["q"];
  $data = array();
  // query your DataBase here looking for a match to $input
  include_once "scripts/connect_to_mysql.php";
  $query = mysql_query("SELECT name,linklabel,permalink FROM tblMerchants WHERE name LIKE '%$input%'");
  while ($row = mysql_fetch_assoc($query)) {
      $json = array();
      $json['name'] = ucwords($row['linklabel']);
      $json['value'] = $row['permalink'];
      $data[] = $json;
  }
  echo json_encode($data); 
  </code></pre>
  
  <p>However, I'm trying to match user input with multiple fields in the table. I'm trying the following and it isn't working:</p>
  
  <pre><code>SELECT linklabel,permalink
  FROM tblMerchants
  WHERE name LIKE '%$input%'
   OR website LIKE '%$input%'
   OR description LIKE '%$input%'
  </code></pre>
  
  <p>Trying to figure this out. Any input is appreciated!</p>
  
  <p>Sorry, should have mentioned this. By not working I mean that when using the multiple LIKE statement its still only returning results that are like 'name'</p>