BETWEEN
Syntax
value1 BETWEEN value2 AND value3
Parameters
Equivalent to value1 >= value2 AND < value3
Description
BETWEEN is a special variant of the comparison predicate. The details of this predicate are important and the order of the operands has some unexpected implications. See the examples section.
*
Examples
SELECT * FROM movie_titles WHERE our_cost BETWEEN 11.00 and 27.50 ;
10 BETWEEN 5 AND 15 Is true, but: 10 BETWEEN 15 AND 5 Is false: