Get Started: SQL IN Operator

In This Article, You Will Know About SQL Wildcard. 

SQL IN Operator – Before moving ahead, let’s know a bit about SQL Wildcard.

Table of Contents

SQL IN Operator

IN Operator – The SQL IN operator is used for matching/ finding out multiple conditions at once.

The IN operator is used with the WHERE clause. In shorthand, it is used as OR conditions.

Syntax

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

or:

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

Example Database

Below is the example of a database table named “details.”

Id

Name

Class

section_id

1

Alex

5

1

2

Rolex

6

2

3

Salex

7

2

4

Lelex

8

3

5

Kelex

9

5

IN Operator Example

Example: Use the IN operator to match the multiple conditions.

				
					SELECT * FROM details
WHERE Name IN ('Alex', 'Rolex');
				
			

As a result, it returns the record after matching the condition.

Example: Use the IN operator to match the multiple conditions.

				
					SELECT * FROM details
WHERE Name  NOT IN ('hlex', 'olex');
				
			

As a result, it returns the record after matching the condition.

Example: Use the IN operator to match the multiple conditions.

				
					SELECT * FROM details
WHERE Name IN (SELECT Name FROM Class);
				
			

As a result, it returns the record after matching the condition.

If you find anything incorrect in the above-discussed topic and have further questions, please comment below.

Connect on:

1 thought on “Get Started: SQL IN Operator”

Leave a Comment

Stay in the loop

codingstreets