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;