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

0 vote206 views1 answer
SQL Error 1040 : Too many connections
SQL
3 votes154 views1 answer
If 0 return null else return query mysql
SQL
2 votes235 views2 answers
Postgres change owner of schema
SQL
0 vote183 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote201 views2 answers
How to find max and min salary in sql
SQL
25 votes211 views5 answers
Date in mysql
SQL
0 vote244 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
23 votes188 views6 answers
How to create table in sql
SQL
0 vote191 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote157 views1 answer
Expose db in virtualbox
SQL