Term: BETWEEN

Definition:
The BETWEEN condition allows retrieving values within a range you specify. It will return the records inclusively, meaning that the end or limit values are also returned. For example, this SQL will return the 'user_id' 1000 through 1050, not 1001 through 1049:

SELECT *

FROM users

WHERE user_id BETWEEN 1000 AND 1050;

The BETWEEN function can be used in any SQL statement, including SELECT, INSERT, UPDATE, and DELETE.

Related Links:

Example SELECT statements using BETWEEN

Related Code Snippets:

Number Functions: Calculate ratio between X and Y columns - This block calculates the ratio betwee...
Months_Between function - The months_between function returns the number of months between date1 a...
Convert between Decimal, Binary, Octal and Hex - This one will solve a lot of your problems. :) ...
Date Functions: MONTHS_BETWEEN - Returns the months in between (separating) two given dates.
Date and Time Calculations: Get seconds between dates - Calculates the number of seconds between t...
BETWEEN Condition - The BETWEEN condition allows you to retrieve values within a range.