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 vote202 views1 answer
Python sqlalchemy connection show server
SQL
0 vote184 views1 answer
Left join in codeigniter query builder
SQL
1 vote191 views1 answer
Postgresql contains
SQL
0 vote205 views1 answer
Make parameters nullable in sql server
SQL
1 vote232 views2 answers
Limit sqlserver
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
2 votes201 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote182 views1 answer
Mysql change default collation
SQL
2 votes183 views2 answers
Created at and updated at in mysql
SQL
10 votes201 views2 answers
Rtrim sql
SQL