Syntax
------ 
expr BETWEEN min AND max
 
Description
----------- 
If expr is greater than or equal to min and expr is less
than or equal
to max, BETWEEN returns 1, otherwise it returns 0. This is
equivalent
to the expression (min 

URL: https://mariadb.com/kb/en/between-and/