MySQL BETWEEN Condition
MYSQL BETWEEN condition used to retrieve values from an expression within a specific range. It is used with SELECT, INSERT, UPDATE and DELETE statement.
MySQL BETWEEN Syntax
expression BETWEEN value1 AND value2;
MySQL BETWEEN Example
SELECT * FROM students WHERE mark BETWEEN 80 and 100;