MySQL AND

MySQL AND

MySQL AND syntax and examples.

MySQL AND syntax

SELECT * FROM table_name
WHERE condition
AND condition;

Table books

IDNAMEPRICE
1book120.0
2book225.0
3book315.0

AND example

SELECT * FROM books 
WHERE id > 1 AND price > 18;

Query Result

IDNAMEPRICE
2book225.0