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

22 votes267 views4 answers
Date format mysql
SQL
2 votes206 views2 answers
Mysql find max value row
SQL
0 vote196 views3 answers
Drop multiple columns in sql
SQL
11 votes196 views1 answer
Mysql text type max length
SQL
1 vote269 views1 answer
Sql oracle update multiple rows
SQL
0 vote233 views1 answer
Sql server beginning of month
SQL
1 vote240 views1 answer
Psql client write to bash variable
SQL
3 votes198 views2 answers
Mysql time
SQL
0 vote212 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote214 views2 answers
Import .sql into postgres db command
SQL