title: Can I use two where clauses, like "SELECT * FROM table WHERE something and something"?
body: <p>I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php):</p>
  
  <pre><code>$query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')";
  </code></pre>
  
  <p>But I only want to select rows where the value for the column "category" equals "bracelet".</p>
  
  <p>I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!</p>