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 vote318 views2 answers
Postgresql list columns
SQL
0 vote339 views1 answer
Not equal to blank in mysql
SQL
0 vote317 views1 answer
Ora 00001 error catch plsql
SQL
1 vote323 views1 answer
Last 6 months postgresql
SQL
0 vote339 views1 answer
Mariadb current date plus 1 day
SQL
0 vote349 views1 answer
Shrink database file in sql server
SQL
0 vote323 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote343 views2 answers
Postgres having
SQL
0 vote306 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote331 views1 answer
Narural join
SQL