MySQL – OR

MySQL’s OR condition specifies that if you take two or more conditions, one of those conditions must be satisfied in order to return records.

Syntax:

WHERE condition1  
OR condition2  
...  
OR condition_n;

condition1, condition2, … condition_n – This section specifies all the conditions that must be met in order to select records.

Example:

SELECT *  
FROM   employees
WHERE last_name = 'Sluis'  
OR emp_no > 1;