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

ID	Title	Price	Description
1	Learn SQL	20	Learn SQL language
2	Learn MySQL	22	Learn MySQL language
3	HTML book	17	Learn HTML
4	Learn PHP	20	Introduction to PHP
5	Learn PHP	20	PHP course

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

Result

ID	Title	Price	Description
4	Learn PHP	20	Introduction to PHP

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

Result

ID	Title	Price	Description
2	Learn MySQL	22	Learn MySQL language
3	HTML book	17	Learn HTML