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

4 votes163 views2 answers
Convert utc to est sql
SQL
0 vote129 views1 answer
Wordpress database query change url
SQL
0 vote166 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote139 views1 answer
Show table details postgresql
SQL
4 votes165 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote88 views1 answer
Oracle character set
SQL
25 votes131 views6 answers
Import mysql database command line
SQL
1 vote129 views1 answer
Pv mysql import
SQL
1 vote205 views1 answer
Primary key reset in SQL database
SQL
3 votes120 views2 answers
Mysql add 2 hours
SQL