The SQLite BETWEEN operator can be used to check if a value is within a given range. Here is what the syntax looks like:
expression BETWEEN lowerlevel AND upperlevel
The SQLite BETWEEN operator replaces the following syntax:
expression >= lowerlevel AND expression <= upperlevel
Or, in other words, the two lines of SQLite code displayed are equivalent. Below code demonstrates how you could make use of the SQLite BETWEEN operator.
SELECT name FROM customers WHERE sales BETWEEN 1000 AND 5000;
Above SQLite SELECT query will return all customer names of customers that have purchased a total invoice value of at least 1000 but no more than 5000.