MySQL IN Operator: Definition, Syntax, and Examples

Tutorial

MYSQL

MySQL Tutorial

MySQL Introduction

MySQL COUNT, AVG, SUM

MySQL Database

MySQL IN

❮ Previous

Next ❯

The IN operator in MySQL is used to filter records based on multiple possible values without using multiple OR condition

Basic Syntax

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

Demo Database

Below is a selection from the "Students" table in the school_db database:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

IN Operator Examples

The following SQL statement selects all studensts that are located in "Bangalore", "Delhi" or "Chicago":

Example

SELECT * FROM students

WHERE city IN ('Bangalore', 'Delhi', 'Chicago');

Try it yourself

The following SQL statement selects all customers that are NOT located in 'Bangalore', 'Delhi' or 'Chicago':

Example

SELECT * FROM students

WHERE city NOT IN ('Bangalore', 'Delhi', 'Chicago');

Try it yourself

The following SQL statement selects all students that are from the course_id where course_id is 101:

Example

SELECT * FROM students

WHERE course_id IN (SELECT course_id FROM courses WHERE course_id = 101);

Try it yourself

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.