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

6 votes73 views2 answers
Can't connect to local mysql server through socket
SQL
1 vote66 views1 answer
Sql select contem uma palavra
SQL
0 vote91 views1 answer
Mssql last day of month
SQL
2 votes81 views4 answers
Check timezone of mysql database
SQL
0 vote72 views1 answer
Mysql update privileges
SQL
5 votes74 views1 answer
JBDC
SQL
7 votes91 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote91 views1 answer
Python mysql show databases
SQL
0 vote66 views1 answer
Sql server whoami
SQL
2 votes74 views1 answer
How to search table name in stored procedure in sql server
SQL