我可以使用两个where子句，例如“SELECT * FROM table WHERE something and something”？

Question

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):

$query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')";

But I only want to select rows where the value for the column "category" equals "bracelet".

I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

Answer 1

$query = "SELECT * FROM products WHERE products.colors LIKE '%black%' AND products.category = 'bracelet'";

There you go.