MySQL OR

MySQL OR

MySQL OR syntax and examples.

MySQL OR syntax

SELECT * FROM table_name
WHERE condition
OR condition;

Table books

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

OR example

SELECT * FROM books 
WHERE id > 1 
AND (price > 10 OR price < 25);

Query Result

ID NAME PRICE
2 book2 25.0
3 book3 15.0