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 vote185 views1 answer
Change filed order in mysql
SQL
0 vote140 views1 answer
Mysql convert column to uppercase
SQL
0 vote184 views1 answer
Sqlite to csv statement
SQL
0 vote171 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
2 votes167 views1 answer
Get first 3 letters name in sql
SQL
1 vote141 views1 answer
Alter user mysql native password
SQL
0 vote210 views1 answer
How do I insert a blob in SQL?
SQL
2 votes194 views1 answer
Mysql shell insert into
SQL
3 votes194 views1 answer
Postgres count distinct
SQL
4 votes191 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL