SQL IN
The most common use for the IN command is comparing a column to multiple possible values.
-- Works in PostgreSQL, MySQL, SQL Server, and Oracle.
SELECT
*
FROM
tenants
WHERE
id IN (1, 4);
tenants table
| id | name |
|---|---|
| 1 | Albert |
| 2 | Marie |
| 3 | Jose |
| 4 | Terrell |
Query results
| id | name |
|---|---|
| 1 | Albert |
| 4 | Terrell |