title: PHP searching multiple rows in database
body: <p>I am wanting to search more than column from one database with PHP and MySQL. Currently I have this working.</p>
  
  <p>This is my form:</p>
  
  <pre><code>  &lt;form action="products.php" method="POST"&gt;
    Search: &lt;input type="text" name="search" /&gt;
    &lt;input type="submit" value="submit"/&gt;
    &lt;/form&gt;
  </code></pre>
  
  <p>and here is my current working query:</p>
  
  <pre><code>$query = "SELECT * FROM `GraphicsCards` WHERE `Brand` LIKE '%". $search . "%'";
  $run = mysqli_query ($connection, $query);
  </code></pre>
  
  <p>As you can see my query is searching my database to see if the user search entered matches anything in the column "Brand".</p>
  
  <p>I have other columns such as "Model" "Price" etc etc, and would like to be able to search those as well as just "Brand". Is it possible to do this is one query?</p>
  
  <p>In addition I have already tried ' AND ' and ' OR ' and also ' || ' but they do not work.</p>