MySQL Tutorial
The IN operator allows you to specify multiple values in a WHERE clause
The IN operator is a shorthand for multiple OR conditions
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
Let's put these statements into real use.
We've a table named Students in our database that contains the following records:
ROLL_NO | NAME | SUBJECT |
---|---|---|
1 | Will | JAVA |
2 | SAM | Python |
3 | Sara | HTML | 4 | Rim | Java |
5 | Micheal | SQL |
6 | Lara | JAVA |
Now lets select multiple values in a WHERE clause from Students table.
SELECT *
FROM Students
WHERE SUBJECT IN ('Python', 'HTML', 'SQL');
The above SQL statement selects all students that learn subject IN 'Python', 'HTML' or 'SQL':
ROLL_NO | NAME | SUBJECT |
---|---|---|
2 | SAM | Python |
3 | Sara | HTML |
5 | Micheal | SQL |
Now lets select all students that learn subject NOT IN 'Python', 'HTML' or 'SQL':
SELECT *
FROM Students
WHERE SUBJECT NOT IN ('Python', 'HTML', 'SQL');
The above SQL statement selects all students that learn subject NOT IN 'Python', 'HTML' or 'SQL':
ROLL_NO | NAME | SUBJECT |
---|---|---|
1 | Will | JAVA |
4 | Rim | Java |
6 | Lara | JAVA |