Finds values for fieldname in the range of minimumvalue to maximumvalue, inclusive. Equivalent to fieldname >= minimumvalue and fieldname <= maximumvalue. Using the BETWEEN operator results in better overall performance than using >= or <=.

 

Example:

SELECT productid FROM products WHERE productid BETWEEN 1 and 100