The usage of between clause in Mysql is detailed _mysql

You can use the IN clause instead of the combined "greater than equals and less than equals" condition.

The EMPLOYEE_TBL table to understand the BETWEEN clause has the following records:

Mysql> SELECT * from EMPLOYEE_TBL;
+------+------+------------+--------------------+
| id |  name | work_date | daily_typing_pages
| +------+------+------------+--------------------+
|  1 | John | 2007-01-24 |        The |
|  2 | Ram | 2007-05-27 |        The |
|  3 | Jack | 2007-05-06 |        170 |
|  3 | Jack | 2007-04-06 |        |
|  4 | Jill | 2007-04-06 |        The |
|  5 | Zara | 2007-06-06 |        A |
|  5 | Zara | 2007-02-06 |        |
+------+------+------------+--------------------+
7 rows in Set (0.00 sec)

Now, suppose you want to get a record condition daily_typing_pages more than 170, equal to and less than 300 according to the table above. This can be >= and <= using the following conditions

Mysql>select * from Employee_tbl 
  ->where daily_typing_pages >= 170 and
  ->daily_typing_pages <= ;
+------+------+------------+--------------------+
| id |  name | work_date | daily_typing_pages
| +------+------+------------+--------------------+
|  1 | John | 2007-01-24 |        The |
|  2 | Ram | 2007-05-27 |        The |
|  3 | Jack | 2007-05-06 |        170 |
|  4 | Jill | 2007-04-06 |        The |
|  5 | Zara | 2007-06-06 |        |
+------+------+------------+--------------------+
5 rows in Set (0.03 sec)

The same can be accomplished using the between clause as follows:

Mysql> SELECT * from Employee_tbl 
  -> WHERE daily_typing_pages BETWEEN 170 and; 
+------+------+------------+--------------------+
| id |  name | work_date | daily_typing_pages
| +------+------+------------+--------------------+
|  1 | John | 2007-01-24 |        The |
|  2 | Ram | 2007-05-27 |        The |
|  3 | Jack | 2007-05-06 |        170 |
|  4 | Jill | 2007-04-06 |        The |
|  5 | Zara | 2007-06-06 |        |
+------+------+------------+--------------------+
5 rows in Set (0.03 sec)