Mysql Count with DAYOFWEEK AND BETWEEN 不能一起工作

Question

我正在尝试计算一个值，其中我从工作日和一年中的前 3 个月获得计数。

SELECT 
  SUM(count_LP) AS down1 
FROM
  `splittest` 
WHERE DAYOFWEEK(DATE) = 2 
  AND (
    dato BETWEEN 2014-01-01 
    AND 2014-04-01
  )

当我添加 BETWEEN 时它停止工作。

有什么想法吗？

Answer 1

要指定日期，您必须像 '2014-01-01' 一样引用它们

SELECT 
  SUM(count_LP) AS down1 
FROM
  `splittest` 
WHERE DAYOFWEEK(DATE) = 2 
  AND (
    dato BETWEEN '2014-01-01' 
    AND '2014-04-01'
  )