Advanced Data Filtering - MariaDB Crash Course - page 53

Using the IN Operator
Parentheses have another different use in WHERE clauses. The IN operator is
used to specify a range of conditions, any of which can be matched. IN takes a
comma-delimited list of valid values, all enclosed within parentheses. The fol-
lowing example demonstrates this:
▼ Input
SELECT prod_name, prod_price
FROM products
WHERE vend_id IN (1002,1003)
ORDER BY prod_name;
▼ Output
+----------------+------------+
| prod_name | prod_price |
+----------------+------------+
| Bird seed | 10.00 |
| Carrots | 2.50 |
| Detonator | 13.00 |
| Fuses | 3.42 |
| Oil can | 8.99 |
| Safe | 50.00 |
| Sling | 4.49 |
| TNT (1 stick) | 2.50 |
| TNT (5 sticks) | 10.00 |
+----------------+------------+
▼ Analysis
The SELECT statement retrieves all products made by vendor 1002 and vendor
1003 . The IN operator is followed by a comma-delimited list of valid values,
and the entire list must be enclosed within parentheses.
If you are thinking that the IN operator accomplishes the same goal as OR , you
are right. The following SQL statement accomplishes the exact same thing as
the previous example:
▼ Input
SELECT prod_name, prod_price
FROM products
WHERE vend_id = 1002 OR vend_id = 1003
ORDER BY prod_name;