How To Use IN, NOT IN Operator In SQL

In this article, we will learn how to use the IN and NOT IN operator with a SQL select query.

The IN operator can be used to specify multiple values in a WHERE clause.

The IN operator is a shorthand, to remove the need of multiple OR conditions.

Syntax

SELECT column_name(s)
FROM TABLE_NAME
WHERE column_name IN (value1, value2, ...valueN);

or

SELECT column_name(s)
FROM TABLE_NAME
WHERE column_name IN (SELECT STATEMENT);

Example-1

The subsequent statement would return all articles with a Title “Introduction” or “Concept of SQL”.

SELECT * FROM Article
WHERE Title IN ('Introduction', 'Concept of SQL');

Example-2

The subsequent statement would return all articles that are from the same “TechID” as the technology.

SELECT * FROM Article
WHERE TechID IN (SELECT ID FROM Technology);

Example-3

The subsequent statement would return all articles without a Title “Introduction” or “Concept of SQL”.

SELECT * FROM Article 
WHERE Title NOT IN ('Introduction', 'Concept of SQL');

 

Also, check How To Use LIKE Operator With Wildcard Characters In SQL