MySQL中BETWEEN子句的用法详解
可以使用IN子句来代替相结合的“大于等于和小于等于”的条件。
要了解BETWEEN子句考虑的EMPLOYEE_TBL表有以下记录：
mysql>SELECT*FROMemployee_tbl; +------+------+------------+--------------------+ |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| |3|Jack|2007-04-06|100| |4|Jill|2007-04-06|220| |5|Zara|2007-06-06|300| |5|Zara|2007-02-06|350| +------+------+------------+--------------------+ 7rowsinset(0.00sec)
现在，假设根据上表想获取记录条件daily_typing_pages超过170，等于和小于300。这可以使用如下条件>=和<=
mysql>SELECT*FROMemployee_tbl ->WHEREdaily_typing_pages>=170AND ->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| +------+------+------------+--------------------+ 5rowsinset(0.03sec)
同样可以实现使用BETWEEN子句如下：
mysql>SELECT*FROMemployee_tbl ->WHEREdaily_typing_pagesBETWEEN170AND300; +------+------+------------+--------------------+ |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| +------+------+------------+--------------------+ 5rowsinset(0.03sec)
热门推荐
10 财运虎年祝福语简短语
11 单亲爸爸春节祝福语简短
12 狗狗上厕所训练
13 植物种植祝福语简短
14 翻译考试祝福语朋友简短
15 个人周年庆简短祝福语
16 狗狗怎么训练
17 分别祝福语简短搞笑英文
18 生日广州男生祝福语简短