MySQL IN Operator

MySQL IN Operator

The IN operator in MySQL is used in the WHERE clause to specify multiple values in a condition. It is a shorthand for using multiple OR conditions.

✅ Syntax

• Returns all rows where the column value matches any value in the list.

🧠 Example Table: students

✅ Example 1: Select Specific Cities

✔ Returns:

✅ Example 2: Select Multiple Ages

✔ Returns students with age 20 or 22:

✅ Example 3: NOT IN

You can also exclude specific values using NOT IN:

✔ Returns students not in New York or London:

🧠 Benefits of Using IN

• Simplifies queries compared to multiple OR conditions:

• Makes queries cleaner and more readable.

✅ Summary