Question

sql语句 between 加条件

我现在用的是这个语句
str="select * from ckd where xssj between #"&start_date&"# and #"&start_date1&"#"
我还需要在这个查询的基础上，增加查询的限制，比如A字段的值必需=11
这样应该怎么改这个语句呢？？？

Answer 1

str="select * from ckd where xssj between #"&start_date&"# and #"&start_date1&"# and A=11"

这样写是没错，不过一定要注意你的 start_date 和 start_date1 要做过滤，否则就注入了

Answer 2

BETWEEN 操作符
操作符 BETWEEN ... AND 会选取介于两个值之间的数据范围。这些值可以是数值、文本或者日期。
例子：

SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2

当然也可以使用 NOT BETWEEN AND 表示不在什么到什么之间的
SELECT * FROM Persons
WHERE LastName
NOT BETWEEN 'Adams' AND 'Carter'

Answer 3

str="select * from ckd where xssj between #"&start_date&"# and #"&start_date1&"# and A=11"

Answer 4

str="select * from ckd where xssj between #"&start_date&"# and #"&start_date1&"#" and A=11