首页 > 代码库 > BETWEEN ADN 查询
BETWEEN ADN 查询
语法:SELECT 字段名1, 字段名2, ...... , 字段名n FROM 表名 WHERE 查询条件 BETWEEN ... AND ... ;
mysql> SELECT f_name, f_price FROM fruits WHERE f_price BETWEEN 2.00 AND 10.20 ;+------------+---------+| f_name | f_price | # 查询价格在2.00到10.20元之间的水果名称和价格+------------+---------+| apple | 5.20 || apricot | 2.20 || blackberry | 10.20 || berry | 7.60 || xxxx | 3.60 || melon | 8.20 || cherry | 3.20 || lemon | 6.40 || xbabay | 2.60 || coconut | 9.20 || grape | 5.30 || xbababa | 3.60 |+------------+---------+
mysql> SELECT f_name, f_price FROM fruits WHERE f_price NOT BETWEEN 2.00 AND 10.20 ;+--------+---------+ | f_name | f_price | # 查询价格不在2.00到10.20元之间的水果名称和价格+--------+---------+| orange | 11.20 || mango | 15.70 || xxtt | 11.60 || banana | 10.30 |+--------+---------+
BETWEEN ADN 查询
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。