Can I use two where clauses, like "SELECT * FROM table WHERE something and something"?

php mysql sql

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

There you go.

php mysql sql

You can do:

SELECT * FROM products WHERE colors LIKE '%black%' AND category = 'bracelet'

CodeHunter