我试图在Mysql中查找60天以上但90天以下的记录。60多天有效,但我似乎不能只得到不超过89天的记录。
SELECT * FROM signings WHERE datediff(now(), signstart) > 60 < 90
尝试
SELECT * FROM signings WHERE datediff(now(), signstart) > 60 and datediff(now(), signstart) < 90
SELECT * FROM signings WHERE signstart BETWEEN
DATE_SUB(NOW(), INTERVAL 90 day) AND DATE_SUB(NOW(), INTERVAL 30 day)