Description

The SQL keyword OR is used to combine two conditions and return TRUE when either of them is TRUE.

SELECT With OR

The below SQL fetches all the customers having the country equal to "Germany" or "Spain".

SELECT *
FROM customers
WHERE country = 'Germany' OR country = 'Spain';

UPDATE With OR

The below SQL updates all the customers having the country equal to "Germany" or "Spain".

UPDATE customers
SET address = '123 ABC STREET'
WHERE country = 'Germany' OR country = 'Spain';

DELETE With OR

The below SQL deletes all the customers having the country equal to "Germany" or "Spain".

DELETE customers
WHERE country = 'Germany' OR country = 'Spain';

Related Links