Learn
Similar to AND
, the OR
operator can also be used to combine multiple conditions in WHERE
, but there is a fundamental difference:
AND
operator displays a row if all the conditions are true.OR
operator displays a row if any condition is true.
Suppose we want to check out a new movie or something action-packed:
SELECT * FROM movies WHERE year > 2014 OR genre = 'action';
year > 2014
is the 1st condition.genre = 'action'
is the 2nd condition.OR
combines the two conditions.
With OR
, if any of the conditions are true, then the row is added to the result.
Instructions
1.
Let’s test this out:
SELECT * FROM movies WHERE year > 2014 OR genre = 'action';
2.
Suppose we are in the mood for a good laugh or a good cry.
Using OR
, write a query that returns all movies that are either a romance or a comedy.
Take this course for free
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.