MySQL BETWEEN Operator

MySQL BETWEEN Operator

The BETWEEN operator in MySQL is used in a WHERE clause to filter the result set within a specific range of values. It can be used with numbers, dates, or text.

✅ Syntax

• Returns all rows where the column value is greater than or equal to value1 and less than or equal to value2.

• Inclusive of both ends (value1 and value2).

🧠 Example Table: students

✅ Example 1: Numbers (Range of Ages)

✔ Returns students with age 20, 21, or 22:

✅ Example 2: Numbers (Range of Marks)

✔ Returns students with marks between 80 and 90 (inclusive):

✅ Example 3: Dates

Assume a table orders:

✔ Returns orders on Nov 5 and Nov 10 as well as dates in between.

✅ Example 4: NOT BETWEEN

You can exclude values outside a range:

✔ Returns students younger than 20 or older than 22:

🏁 Summary