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

2 votes165 views3 answers
Current month mysql query
SQL
12 votes156 views2 answers
Delete all data in neo4j
SQL
3 votes160 views2 answers
Oracle grants
SQL
9 votes164 views2 answers
Nosql databases
SQL
0 vote229 views2 answers
Cascade syntax in sql
SQL
1 vote167 views2 answers
Mysql join two tables
SQL
1 vote185 views3 answers
Connection string mysql
SQL
4 votes158 views2 answers
Mysql how to change default charset
SQL
9 votes182 views2 answers
Sql server check table exists
SQL
1 vote179 views1 answer
Write a query to create an empty table from an existing table?
SQL