Range comparison is done with
BETWEEN operator is inclusive, begin and end value is included.
Get the name and salary of employees where salary is between 80,000 and 90,000
SELECT name, salary FROM employees WHERE salary BETWEEN 80000 AND 90000
You can write the equivalent SQL in the following way
SELECT name, salary FROM employees WHERE salary >= 80000 AND salary <= 90000
You can use MySQL BETWEEN operator with dates also.