MySQL BETWEEN Operator: Definition, Syntax, and Examples

Tutorial

MYSQL

MySQL Tutorial

MySQL Introduction

MySQL COUNT, AVG, SUM

MySQL Database

MySQL BETWEEN

❮ Previous

Next ❯

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 ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.