The MYSQL BETWEEN condition specifies how to retrieve values from an expression within a specific range. It is used with SELECT, INSERT, UPDATE and DELETE statement.
Syntax:
expression BETWEEN value1 AND value2;
expression: It specifies a column.
value1 and value2: These values define an inclusive range that expression is compared to.
Let's take some examples:
Consider a table "officers" having the following data.
Execute the following query:
SELECT * FROM officers WHERE officer_id BETWEEN 1 AND 3;
Output:
Note: In the above example, you can see that only three rows are returned between 1 and 3.
MySQL BETWEEN condition also facilitates you to retrieve records according to date.
See this example:
Consider a table "employees", having the following data.
Execute the following query:
SELECT *
FROM employees
WHERE working_date BETWEEN CAST ('2015-01-24' AS DATE) AND CAST ('2015-01-25' AS DATE);Output:
Note: In the above example you can see that only data between specific dates are shown.
