MySQL SQL

MySQL AND

Require multiple conditions to be true.

Combine conditions

SELECT * FROM products
WHERE price > 500 AND stock > 0;

AND returns a row only when every condition matches. Use parentheses when combining AND with OR.