mysql between用法

mysql中的between and用于将一定范围内的数据取出,包含了边界值, 查看ID号在20至50之间的用户,包含20和50:

SELECT * FROM user WHERE uid BETWEEN 20 AND 50

还可以查看在字符范围内的,应该是按ASCII码排序

SELECT * FROM user WHERE name BETWEEN a AND e;

between and 比较时间,可以是从1970-01-01 00:00:00的秒数,如1387210733,可以是date格式,也可以是datetime格式。如

SELECT * FROM user WHERE rtime BETWEEN '2010-08-10' AND '2013-12-10';

发表评论

电子邮件地址不会被公开。 必填项已用*标注