Mysql 查询不适用于 WHERE BETWEEN

Question

我试图从数据库中获取一些数据，但目前只收到错误。

我正在尝试执行的查询=

SELECT 
   count(id), 
   day(created_at), 
   year(created_at), 
   month(created_at) 
FROM 
   `orders` 
WHERE 
   day(created_at) = BETWEEN 1 AND 7 month(created_at) = 6 
   AND year(created_at) = 2014 
   AND company_id = 1 
group by 
   year(created_at), 
   month(created_at), 
   day(created_at)

1 到 7 之间的日子是周日到周六，以获得该周的所有订单。

提前致谢。

Answer 1

您的查询有误。这应该是:

  SELECT count(id), day(created_at), year(created_at), month(created_at) 
      FROM `orders` WHERE day(created_at) BETWEEN 1 AND 7 
            AND month(created_at) = 6 AND year(created_at) = '2014' 
            AND company_id = 1 
        group by year(created_at), month(created_at), day(created_at)

您在同一位置使用 = 和 BETWEEN，这是不正确的。