Sql where clause multiple values

Sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

Source: grepper.com

Specify multiple values in a WHERE clause SQL

-- The IN operator allows you to specify multiple values in a WHERE clause.
SELECT example_column
FROM exaple_table
WHERE example_column IN (example_value1, example_value2, example_value3);

Source: campus.datacamp.com

Similar codes

-1 vote248 views1 answer
MYSQL stored procedure select from
SQL
1 vote240 views1 answer
Set statiscis on in sql server
SQL
0 vote179 views1 answer
Sequelize postgresql schema
SQL
1 vote197 views1 answer
Psql lst trigger
SQL
7 votes198 views3 answers
Select latest entry in sql table
SQL
18 votes195 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
8 votes250 views3 answers
Postgres database sizes
SQL
0 vote183 views1 answer
Coalesce for comma separated in sql server
SQL
8 votes204 views1 answer
Oracle search text in all packages
SQL
7 votes204 views6 answers
Group_concat in mysql
SQL