Javatpoint Logo
Javatpoint Logo

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.

MySQL IN Condition 1

Execute the following query:

Output:

MySQL IN Condition 2

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

Execute the following query:

Output:

MySQL IN Condition 3

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





Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA