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 vote340 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote352 views1 answer
Get current date data in mysql
SQL
0 vote358 views1 answer
How to select a row in sql
SQL
0 vote347 views1 answer
Insensitive case match sqlalchemy
SQL
3 votes324 views1 answer
Sql cast to integer
SQL
0 vote335 views1 answer
Dnsmasq.conf location macos
SQL
1 vote337 views1 answer
Mysql limit results to 10
SQL
15 votes343 views2 answers
Open postgress in terminal mac
SQL
0 vote358 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote352 views1 answer
Setting default value for Boolean data type in SQL
SQL