MySQL Tutorial
MySQL Workbench
- mysql-workbench
User Management
MySQL Database
Table & Views
MySQL Queries
MySQL Indexes
MySQL Clauses
MySQL Privileges
- mysql-grant-privilege
- mysql-revoke-privilege
Control Flow Function
MySQL Conditions
MySQL Join
MySQL Key
MySQL Triggers
Aggregate Functions
MySQL Misc
MySQL Globalisation
- mysql-character-set
- mysql-collation
Regular Expressions
FULLTEXT Search
Differences
Interview Questions

MySQL IN Condition

The MySQL IN condition is used to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE and DELETE statement.

Syntax:

Parameters

expression: It specifies a value to test.

value1, value2, ... or value_n: These are the values to test against expression. If any of these values matches expression, then the IN condition will evaluate to true. This is a quick method to test if any one of the values matches expression.

MySQL IN Example

Consider a table "officers", having the following data.

Execute the following query:

SELECT *
FROM officers
WHERE officer_name IN ('Ajeet', 'Vimal', 'Deepika');

Output:

Let's see why it is preferred over OR condition:

Execute the following query:

SELECT *
FROM officers
WHERE officer_name = 'Ajeet'
OR officer_name = 'Vimal'
OR officer_name = 'Deepika';

Output:

It also produces the same result. So IN condition is preferred over OR condition because it has minimum number of codes.

Next TopicMySQL ANY

← prev next →

Hot Tutorials

Contact US

Email:[email protected]

MySQL IN

10/30

MySQL Tutorial

MySQL Workbench

User Management

MySQL Database

Table & Views

MySQL Queries

MySQL Indexes

MySQL Clauses

MySQL Privileges

Control Flow Function

MySQL Conditions

MySQL Join

MySQL Key

MySQL Triggers

Aggregate Functions

MySQL Misc

MySQL Globalisation

Regular Expressions

FULLTEXT Search

Differences