MySQL OR

The OR operator is used to combine multiple conditions in an SQL statement’s WHERE clause.

Syntax:

The basic syntax of OR operator with WHERE clause is as follows:

SELECT column1, column2, columnN FROM table_name WHERE [condition1] OR [condition2]…OR [conditionN];

Ex:

SELECT * FROM CUSTOMERS WHERE AGE >= 25 OR SALARY >= 6500;