MySQL IN Clause

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