Between

El operador BETWEEN es inclusivo: los valores inicial y final son incluidos.

WHERE column_name BETWEEN value1 AND value2;

es una abreviatura de:

WHERE column_name>=value AND column_name<=value;