SQL · Reading data

in list

Matches any value in a list. Faster to read than chained ORs.

sqlRunnable example sql course

Syntax

where status in (…)

Example

Open in the lab

WITH lessons(status) AS (VALUES ('draft'), ('published'))
SELECT status FROM lessons WHERE status IN ('published');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.