1# The BETWEEN operator is inclusive
2# The expression:
3a BETWEEN b AND c
4# is really just shorthand, equivalent to this:
5( a >= b AND a <= c )
6
7
8# If that's not the condition you want,
9# you can use different comparison operators:
10( a > b AND a < c )
1/*the BETWEEN operator is used to filter the result set within
2a certain range. the values can be numbers, texts or dates */
3SELECT column_name(s)
4FROM table_name
5WHERE column_name BETWEEN value1 AND value2;
1SELECT column_name(s)
2FROM table_name
3WHERE column_name BETWEEN value1 AND value2;