Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Queries

Or

Similar to AND, the OR operator can also be used to combine multiple conditions in WHERE, but there are some fundamental differences.

Suppose we want to check out a new movie or something action-packed:

SELECT * FROM movies WHERE year > 2014 OR genre = 'action';

1. year > 2014 is the 1st condition.

2. genre = 'action' is the 2nd condition.

3. OR combines the two conditions.

OR Venn Diagram

With OR, if any of the conditions are true, then the row is added to the result.

Report a Bug
If you see a bug or any other issue with this page, please report it here.