php - 仅显示 MySQL future 的数据库记录

Question

我试图仅显示当前日期之前两周的记录。 starttime 在数据库中存储为 datetime 数据类型。

我有这个，

       SELECT id, date_format(starttime, '%d-%m-%Y %H:%i') AS formatted_start, date_format(starttime, '%Y-%m-%d') AS formatted_date, 
    date_format(endtime, ' %H:%i') AS formatted_end 
    FROM timedates WHERE user_id = 1 AND `status`='' AND  YEARWEEK(formatted_date, 0) IN (YEARWEEK(NOW(), 0), 
YEARWEEK(DATE_ADD(NOW(), INTERVAL 2 WEEK), 0))

但我收到语法错误 YEARWEEK(formatted_date, 0) IN (YEARWEEK(NOW(), 0) AND YEARWEEK(DATE_ADD(NOW())

谁能告诉我这是怎么回事吗？

Answer 1

MySQL 似乎不支持 where 子句中的计算列:

尝试

SELECT id, date_format(starttime, '%d-%m-%Y %H:%i') AS formatted_start, 
date_format(starttime, '%Y-%m-%d') AS formatted_date, 
date_format(endtime, ' %H:%i') AS formatted_end 
FROM timedates 
WHERE user_id = 1 AND `status`='' AND  
YEARWEEK(starttime, 0) IN (
 YEARWEEK(DATE_ADD(NOW(), INTERVAL 1 WEEK), 0), 
 YEARWEEK(DATE_ADD(NOW(), INTERVAL 2 WEEK), 0))

使用开始时间而不是formatted_date