MySQL BETWEEN Operator

The BETWEEN operator is used to select values within a range.

Syntax

 SELECT columnName  
 FROM tableName  
 WHERE columnName BETWEEN value1 AND value2;  

Demo 

 SELECT * FROM employee_tbl   
 WHERE daily_typing_pages BETWEEN 170 AND 300;