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 |