SELECT * FROM TABLENAME WHERE RQ BETWEEN '2007-7-4' AND '200

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/05/04 01:27:04

SELECT * FROM TABLENAME WHERE RQ BETWEEN '2007-7-4' AND '2007-8-10'
数据库中RQ列是VARCHAR(10),格式是'YYYY-M-D'
用这个查找不出 2007-7-4至2007-7-31的数据是为什么呢?

因为是文本2007-7-4 大于2007-7-31；所以2007-7-10到2007-7-31应该是查不出来的,
其排序为：2007-7-10
2007-7-11
2007-7-12
2007-7-13
2007-7-14
2007-7-15
2007-7-16
2007-7-17
2007-7-18
2007-7-19
2007-7-20
2007-7-21
2007-7-22
2007-7-23
2007-7-24
2007-7-25
2007-7-26
2007-7-27
2007-7-28
2007-7-29
2007-7-30
2007-7-31
2007-7-4
2007-7-5
2007-7-6
2007-7-7
2007-7-8
2007-7-9
2007-8-1
2007-8-2
2007-8-3
2007-8-4
2007-8-5
2007-8-6