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.

Table Of Contents−

Syntax:

SELECT <field1, field2,...>
FROM <table_name>
WHERE <field> IN (value1,value2,...)

SELECT <field1, field2,...>

FROM <table_name>

WHERE <field> IN (value1,value2,...)

Consider “emp_info” table:

SELECT * FROM emp_info
WHERE EMPNAME IN ('Mark','Max')

1 2	SELECT * FROM emp_info WHERE EMPNAME IN ('Mark','Max')

Output:

In this tutorial we have learn about the MySQL IN Clause and its application with practical example. I hope you will like this tutorial.