Mysql 哪里等于？

Question

我有一个mysql函数

SELECT * FROM `stats` WHERE BETWEEN '2011-01-03' AND '2011-01-01' AND `email`='sarah@sarah.com' AND `city`='New York' AND `location`='New York' AND `date` GROUP BY action

但是我似乎无法让它工作，如果我取出 BETWEEN '2011-01-03' AND '2011-01-01' 但没有它，它会工作，我怎样才能使这个功能工作？

Answer 1

WHERE BETWEEN '2011-01-03' AND '2011-01-01'

需要一个要比较的列名。它是 date 列吗？

那么你的查询应该是这样的:

SELECT *
FROM `stats`
WHERE `date` BETWEEN '2011-01-01' AND '2011-01-03'
AND `email`='sarah@sarah.com'
AND `city`='New York'
AND `location`='New York'
GROUP BY action