MySQL BETWEEN Clause

In this tutorial you will learn about the MySQL BETWEEN Clause and its application with practical example.

The BETWEEN operator is used in combination with WHERE clause match or select a range of data value between two values.

Table Of Contents−

Syntax:

SELECT <field1, field2,...>
FROM <table_name>
WHERE <field_name>
BETWEEN value1 AND value2

SELECT <field1, field2,...>

FROM <table_name>

WHERE <field_name>

BETWEEN value1 AND value2

Consider “emp_info” table:

SELECT * FROM emp_info
WHERE SALE
BETWEEN 1000 AND 2000;

SELECT * FROM emp_info

WHERE SALE

BETWEEN 1000 AND 2000;

Output:

In this tutorial we have learn about the MySQL BETWEEN Clause and its application with practical example. I hope you will like this tutorial.