Range Conditions
The BETWEEN
operator tests whether a value is in a specific range of values. It returns true if the value being tested is greater than or equal to a low value and less than or equal to a high value.
Syntax
expr [ NOT ] BETWEEN expr AND expr
Example
7 NOT BETWEEN 10 AND 15
is true.