mysql - SQL查询: BETWEEN

Question

这个问题已经有答案了:

Mysql: Select all data between two dates (7 个回答)

已关闭 6 年前。

我正在尝试执行查询来获取 between数据值。

我在这里看到了一些问题，但我的查询更复杂。

这是查询:

SELECT calendar.datefield AS DATE, 
IFNULL( count( lead.insertDate ) , 0 ) AS task
FROM lead 
RIGHT JOIN calendar ON ( DATE( lead.insertDate ) = calendar.datefield ) 
AND lead.lpid =  '40' 
WHERE insertDate BETWEEN '2016-01-05' AND '2016-01-23'
GROUP BY DATE

我认为问题出在查询语法中，查询工作正常，直到我添加 where行。

Answer 1

您已将条件置于 where 子句之外。试试这个。

SELECT calendar.datefield AS DATE, 
IFNULL( count( lead.insertDate ) , 0 ) AS task
FROM lead 
RIGHT JOIN calendar ON ( DATE( lead.insertDate ) = calendar.datefield )  
WHERE insertDate BETWEEN '2016-01-05' AND '2016-01-23'
AND lead.lpid =  '40'
GROUP BY DATE