php - mysql 查询今天和明天的日期

Question

SELECT
   doctors. fullname,
   dutyroster.date,
   dutyroster.time
FROM
   dutyroster
INNER JOIN doctors ON doctors.docid = dutyroster.docid
WHERE doctors.docid = $doc_id AND
dutyroster.date = DATE(NOW()) AND DATE(NOW())+ INTERVAL 1 DAY
ORDER BY dutyroster.`date`  ASC";

此查询用于从名为 Dutyroster 的表中查找特定医生信息。我只想获取当天和明天的文档时间表信息..但这不起作用。

我做了第二个，但也不起作用，因为它返回当前日期和所有下一个日期

SELECT
    doctors. fullname,
    dutyroster.date,
    dutyroster.time
FROM
    dutyroster
INNER JOIN doctors ON doctors.docid = dutyroster.docid
WHERE doctors.docid = $doc_id AND
DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= dutyroster.date
ORDER BY dutyroster.`date`  ASC"

Answer 1

而不是

... AND dutyroster.date = DATE(NOW()) AND DATE(NOW())+ INTERVAL 1 DAY

尝试

... AND (dutyroster.date = CURDATE() OR 
         dutyroster.date = CURDATE() + INTERVAL 1 DAY))

或更简洁的方式，如@MarcM建议的

... AND dutyroster.date IN (CURDATE(), CURDATE() + INTERVAL 1 day)