MySQL 查询使用 Between 获取两个值

Question

我需要从 mysql 数据库中选择数据。我从“FORM”VENUE=10000003、START_DATE=1452673900 和 END_DATE=1452663000 提交值。

数据库中存在startDate=1452673800和endDate=1452663000和venue=10000003

但我无法通过此查询得到结果

SELECT * FROM `training_calendar` WHERE `venue`='10000003' AND `startDate` BETWEEN (1452673800 AND 1452663000)
AND `endDate` BETWEEN (1452673800 AND 1452663000)

请帮忙

Answer 1

更改值的位置，最低日期必须位于 BETWEEN 运算符中的第一个:

SELECT * FROM `training_calendar` 
WHERE `venue`='10000003' AND `startDate` BETWEEN 1452663000 AND 1452673800
AND `endDate` BETWEEN 1452663000 AND 1452673800