Databases · Junior · Question 19 of 75

What does `WHERE status IN ('new', 'paid')` mean?

1status contains both words
2status is not new and not paid
✓Correct answer: status equals new or paid

Explanation

It's a short form of status = 'new' OR status = 'paid'. IN also accepts a subquery: WHERE user_id IN (SELECT id FROM ...).

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.