Mega Code Archive

 

Categories / MySQL / Where Clause

 

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";