MySQL IN, BETWEEN and IS NULL

IN: match a list

IN is a short way to write many OR conditions.

SELECT name, city FROM students WHERE city IN ('Delhi', 'Pune');

---

BETWEEN: match a range

BETWEEN includes both end values.

SELECT name, marks FROM students WHERE marks BETWEEN 70 AND 90;

Read Write a query to select students with marks between 70 and 80.

---

IS NULL: find empty values

NULL means “no value”. You cannot test it with =. Use IS NULL and IS NOT NULL.

SELECT name, course_id FROM students WHERE course_id IS NULL;

SELECT COUNT(*) AS with_course FROM students WHERE course_id IS NOT NULL;

---

Summary

• IN (a, b, c) matches any value of the list.
• BETWEEN a AND b includes a and b.
• Use IS NULL and IS NOT NULL for empty values.
• Next: UPDATE.

• Previous Page
• Next Page

---

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.