Combine condition with OR : OR « Where Clause « SQL / MySQL





Combine condition with OR

 
/*

mysql> select * from Student;
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
|         1 | John       | Jones     |
|         2 | Gary       | Burton    |
|         3 | Emily      | Scarlett  |
|         4 | Bruce      | Lee       |
|         5 | Anna       | Wolff     |
|         6 | Vic        | Andrews   |
|         7 | Steve      | Alaska    |
+-----------+------------+-----------+
7 rows in set (0.02 sec)

mysql> select * from Student WHERE first_name="Bruce" OR last_name="Burton" OR
    ->                                  last_name="Wolff";
+-----------+------------+-----------+
| StudentID | first_name | last_name |
+-----------+------------+-----------+
|         2 | Gary       | Burton    |
|         4 | Bruce      | Lee       |
|         5 | Anna       | Wolff     |
+-----------+------------+-----------+
3 rows in set (0.00 sec)


*/
Drop table Student;

CREATE TABLE Student (
   StudentID INT NOT NULL PRIMARY KEY,
   first_name      VARCHAR(50) NOT NULL,
   last_name      VARCHAR(50) NOT NULL
   
)TYPE = InnoDB;


INSERT INTO Student (StudentID,first_name, last_name) VALUES (4,'Bruce', 'Lee');

INSERT INTO Student (StudentID,first_name, last_name) VALUES (1,'John', 'Jones');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (2,'Gary', 'Burton');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (7,'Steve', 'Alaska');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (5,'Anna', 'Wolff');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (6,'Vic', 'Andrews');
INSERT INTO Student (StudentID,first_name, last_name) VALUES (3,'Emily', 'Scarlett');

select * from Student;

select * from Student WHERE first_name="Bruce" OR last_name="Burton" OR 
                                 last_name="Wolff";
  

           
         
  










Related examples in the same category

1.An OR operator
2.AND and OR may be intermixed
3.Combine conditions in select clause
4.SELECT statement includes two expressions within the WHERE clause
5.SELECT statement includes three expressions connected with an AND operator and an OR operator