在两个具有预定义值的日期属性之间进行选择

Question

我试图在mysql中的两个日期属性之间选择记录，但是我尝试的查询不起作用，可能是因为日期属性不是字符串，所以它无法比较它！

这是我尝试过的查询。

SELECT * 
FROM object, object_info
WHERE oi_object = o_id
AND o_category =  '6'
AND o_address =  'Gostivar'
AND o_status =  'approved'
AND o_available_from >= date(2013-08-15)
AND o_available_to <= date(2013-08-31)
ORDER BY o_date DESC 

Answer 1

您需要将日期值括在单引号中：

SELECT * 
FROM object, object_info
WHERE oi_object = o_id
AND o_category =  '6'
AND o_address =  'Gostivar'
AND o_status =  'approved'
AND o_available_from >= date('2013-08-15')
AND o_available_to <= date('2013-08-31')
ORDER BY o_date DESC ;

您的查询实际上是在执行：

AND o_available_from >= date(2013 - 08 - 15)
AND o_available_to <= date(2013 - 08 - 31)

这就是

AND o_available_from >= date(1980)
AND o_available_to <= date(1974)

我不认为你真的想那样。