chevron_left
Operators
0
0
0
new
MySQL | OR
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightOperators
schedule Mar 10, 2022
Last updated MySQL
Tags tocTable of Contents
expand_more MySQL's OR
operator can be used in conjunction with a WHERE
clause to return values that satisfy at least one of the conditions separated by OR
in the WHERE
clause.
Syntax
SELECT column_name(s)FROM table_nameWHERE condition1 OR condition2;
Examples
Consider the following table about some students:
student_id | fname | lname | day_enrolled | age | username |
---|---|---|---|---|---|
1 | Sky | Towner | 2015-12-03 | 17 | stowner1 |
2 | Ben | Davis | 2016-04-20 | 19 | bdavis2 |
3 | Travis | Apple | 2018-08-14 | 18 | tapple3 |
4 | Arthur | David | 2016-04-01 | 16 | adavid4 |
5 | Benjamin | Town | 2014-01-01 | 17 | btown5 |
The above sample table can be created using the code here.
Basic usage
To return students who are either older than 17
or enrolled after 2017-01-01
:
SELECT * FROM studentsWHERE age > 17 OR day_enrolled > '2017-01-01';
+------------+--------+-------+--------------+------+----------+| student_id | fname | lname | day_enrolled | age | username |+------------+--------+-------+--------------+------+----------+| 2 | Ben | Davis | 2016-04-20 | 19 | bdavis2 || 3 | Travis | Apple | 2018-08-14 | 18 | tapple3 |+------------+--------+-------+--------------+------+----------+
We can see that Ben and Travis are the only students to satisfy at least one of the conditions.
Note that we need to specify the field name for every condition. Therefore, the following syntax is invalid:
SELECT * FROM studentsWHERE age = 17 OR 18;
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_or