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

3 votes167 views2 answers
Mysql select database
SQL
0 vote175 views1 answer
How to run mysql on terminal mac
SQL
6 votes157 views2 answers
Psql load dump
SQL
0 vote109 views1 answer
Calculate discount from original price sql
SQL
0 vote139 views1 answer
Alter table fulltext
SQL
2 votes204 views5 answers
Install postgresql 10 centos 7
SQL
1 vote183 views1 answer
Is sql fast
SQL
22 votes154 views4 answers
Mysql date_format
SQL
-1 vote156 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote163 views1 answer
How to check default value of column in sql server
SQL