MySQL Tutorial

A database system used with PHP.

Chapter Quiz Exercises
Course Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views

MySQL IN

The MySQL IN Operator

The IN operator allows you to specify multiple values in a WHERE clause.

The IN operator is a shorthand for multiple OR conditions.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views