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 vote252 views1 answer
Sql server locks
SQL
2 votes231 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
2 votes245 views1 answer
Docker run postgres locally
SQL
0 vote262 views1 answer
Pgsql is not permitted to log in
SQL
0 vote236 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote265 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote252 views1 answer
Replace multiple string in query sql
SQL
0 vote268 views1 answer
Alter table engine mysql
SQL
0 vote285 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
2 votes257 views1 answer
Postgresql transaction
SQL