MySQL IN Clause

In this tutorial you will learn about the MySQL IN Clause and its application with practical example.

The IN clause is used to match multiple values in a WHERE clause.

Syntax:

Consider “emp_info” table:

empID empName sale
1 Mark 1000
2 Max 1000
3 Mark 1000
4 Mark 1000
5 John 1000

Output:

empID empName sale
1 Mark 1000
2 Max 1000
3 Mark 1000
4 Mark 1000
In this tutorial we have learn about the MySQL IN Clause and its application with practical example. I hope you will like this tutorial.