1. Home
  2. SQL IN operator

The best SQL IN operator Tutorial In 2024, In this tutorial you can learn IN operator,The demo database,IN operator examples,Examples,

SQL IN operator

IN operator

IN operator allows you to multiple values ​​specified in the WHERE clause.

SQL IN syntax

SELECT column_name(s)
FROM table_name
WHERE column_name IN ( value1 , value2 ,/en.);

The demo database

In this tutorial, we will use w3big sample database.

The following is a selected "Websites" table data: 

+----+--------------+---------------------------+-------+---------+
| id | name         | url                       | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1  | Google       | https://www.google.cm/    | 1     | USA     |
| 2  | 淘宝          | https://www.taobao.com/   | 13    | CN      |
| 3  | 本教程      | http://www.w3write.com/    | 4689  | CN      |
| 4  | 微博          | http://weibo.com/         | 20    | CN      |
| 5  | Facebook     | https://www.facebook.com/ | 3     | USA     |
| 7  | stackoverflow | http://stackoverflow.com/ |   0 | IND     |
+----+---------------+---------------------------+-------+---------+

IN operator examples

The following SQL statement select name as "Google" or the "course" of all sites:

Examples

SELECT * FROM Websites
WHERE name IN ( 'Google', 'tutorial');

Execution output:

Hot Tools

Other Tools

Online Tutorial

Website Navigation

SQL IN operator
10/30