展开全部
包含边界的32313133353236313431303231363533e78988e69d8331333365633839,如下:between...prar1 and prar2 相当于>=prar1 and <=prar2;
mysql>
SELECT * FROM employee_tbl
->
WHERE daily_typing_pages >= 170 AND
->
daily_typing_pages <= 300;
+------+------+------------+--------------------+
|
id | name | work_date | daily_typing_pages |
+------+------+------------+--------------------+
| 1 | John | 2007-01-24 | 250 |
| 2 | Ram | 2007-05-27 | 220 |
| 3 | Jack | 2007-05-06 | 170 |
| 4 | Jill | 2007-04-06 | 220 |
| 5 | Zara | 2007-06-06 | 300 |
+------+------+------------+--------------------+
5 rows in set (0.03 sec)
如果用between 2 and 4
相当于大于等于2
小于等于4