Google Ad Slot: content-top

MySQL BETWEEN

MySQL `BETWEEN` Operator

The BETWEEN operator in MySQL is used to filter data within a specified range. It works with numbers, dates, and even text values.

It is inclusive — both endpoints are considered.

BETWEEN Syntax

SELECT column_names
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Demo Database

Below is a selection from the "Students" table in the school_db database:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

BETWEEN Example

The following SQL statement finds students whose scores are from 60 to 80, including both 60 and 80.:

Example

SELECT * FROM students

WHERE score BETWEEN 60 AND 80;

Try it yourself

NOT BETWEEN Example

You can exclude values outside a specific range using NOT BETWEEN.

Example

SELECT * FROM students

WHERE score NOT BETWEEN 40 AND 70;

Try it yourself

BETWEEN Text Values Example

The following SQL statement finds students whose names start from "A" to "M".

Example

SELECT * FROM students

WHERE name BETWEEN 'A' AND 'M';

Try it yourself

Previous Next

Search

Welcome Back

Create Account

Forgot Password

MySQL BETWEEN

MySQL `BETWEEN` Operator

BETWEEN Syntax

Demo Database

BETWEEN Example

NOT BETWEEN Example

BETWEEN Text Values Example

Welcome Back

Create Account

Forgot Password

MySQL BETWEEN

MySQL BETWEEN Operator

BETWEEN Syntax

Demo Database

BETWEEN Example

NOT BETWEEN Example

BETWEEN Text Values Example

MySQL `BETWEEN` Operator