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 votes130 views1 answer
How to select first row of database sql
SQL
0 vote154 views1 answer
Mysql trigger to delete old data
SQL
0 vote166 views1 answer
Mysl like insert a variable
SQL
1 vote160 views1 answer
Drop column if exists sql server
SQL
0 vote130 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote138 views1 answer
Mariadb create index if not exists
SQL
3 votes120 views2 answers
Sql end of month
SQL
1 vote93 views2 answers
Last working day in week date function in sql
SQL
0 vote139 views1 answer
Setval in postgres
SQL
0 vote87 views1 answer
Delete all rows from table sqlite
SQL