OR Keyword

The OR keyword/operator is used with the where clause when we want to check multiple conditions and want any of them to be true.

The OR operators are used to filter records based on more than one condition and need any of the conditions to be true.

Syntax

SQL
SELECT <COLUMNS> FROM <TABLE_NAME> WHERE <CONDITION_1> OR <CONDITION_2>
DELETE FROM <TABLE_NAME> WHERE <CONDITION_1> OR <CONDITION_2>
UPDATE <TABLE_NAME> SET <COLUMN_NAME> = <VALUE> WHERE <CONDITION_1> OR <CONDITION_2>

Example

SQL
SELECT * FROM Employee WHERE Emp_Salary > 50000 OR Emp_Dept = 'Accounts'
DELETE FROM Employee WHERE Emp_Salary > 50000 OR Emp_Dept = 'Accounts'
UPDATE Employee  SET Emp_Salary = Emp_Salary + 5000 WHERE Emp_Salary > 50000 OR Emp_Dept = 'Accounts'

Summary

The OR keyword is used when we want to check more than one condition and also whether any of them is true.