The MySQL Between operator is used to fetch values within a given range. It can be used with SELECT, INSERT, UPDATE and DELETE statement.
To fetch values within a given range, use the following syntax:
tablename: The table name from which you want to perform
expression: Specifies a column name.
value1 AND value2: To define a range that expression is compared to.
BETWEENoperator is used to fetch values within a given range i.e. "pk"
BETWEEN1 and 3:
In the above example, we are fetching values
BETWEEN given range, in abobe example "pk" between 1 and 3.
You can use MySQL Command Line Client to fetch values within a given range. It will look like this: