Operators

AND BETWEEN BINARY CASE DIV IN IS IS NOT IS NOT NULL IS NULL LIKE NOT NOT BETWEEN NOT IN NOT LIKE NOT REGEXP OR REGEX RLIKE SOUNDS LIKE XOR

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

MySQL | OR

Database

MySQL

Documentation

Operators

Mar 10, 2022

Last updated

local_offer MySQL

Syntax


        
        
            
                
                
                    SELECT column_name(s)
FROM table_name
WHERE 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 students
WHERE age = 17 OR 18;

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Share on Twitter

Share on Facebook

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_or

thumb_up

thumb_down

chat_bubble_outline

settings

A modern learning experience for data science and analytics