MySQL AND

MySQL AND

MySQL AND syntax and examples.

MySQL AND syntax

SELECT * FROM table_name
WHERE condition
AND condition;

Table books

ID NAME PRICE
1 book1 20.0
2 book2 25.0
3 book3 15.0

AND example

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

Query Result

ID NAME PRICE
2 book2 25.0