/    /  MySQL – BETWEEN

MySQL – BETWEEN

 

my

BETWEEN conditions in MySQL specify a range of values to retrieve from an expression. The statement is used with SELECT, INSERT, UPDATE, and DELETE.

Syntax:

expression BETWEEN value1 AND value2; 

expression: Specify a column to be displayed.

value1 and value2: Based on these values, expressions are compared against an inclusive range.

Example:

SELECT *  
FROM employees  
WHERE emp_no BETWEEN 10001 AND 10003;

my