IN / BETWEEN
Is it in a list or range?
Syntax
WHERE column IN (a, b);
Description
IN checks if it is one of specific values; BETWEEN checks if it is within a and b.
Example
Loading editor…
Expected output
2
When to use?
Multiple value / range filter.