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 votes116 views1 answer
Oracle trigger after logon on database
SQL
0 vote114 views1 answer
Mysql grouping functions
SQL
0 vote126 views1 answer
Add multiple field in table sql
SQL
0 vote136 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote116 views2 answers
Disallowed function mysql to_date()
SQL
0 vote117 views1 answer
How to print mysql query of codeigniter query builder
SQL
3 votes113 views1 answer
Get all elements sql
SQL
1 vote120 views2 answers
Sql drop multiple columns if exists
SQL
1 vote115 views1 answer
Alphabetical order mysql
SQL
1 vote125 views1 answer
Oracle compile schema
SQL