SQL And – Or

SQL And – Or

AND returns the records if both conditions are true.
OR returns the records if at least one of the conditions is true.

And – Or syntax

SELECT * FROM table_name WHERE condition AND condition;

SELECT * FROM table_name WHERE condition OR condition;

SELECT * FROM table_name WHERE condition AND condition OR condition;

And – Or example

Coder books table

SELECT * FROM coder_books WHERE price = 20 and id=4;

Result

SELECT * FROM coder_books WHERE price = 22 or id=3;

Result