MySQL数据库查询当前时间的前一天最后一笔不为空的数据

Question

MySQL数据库查询当前时间的前一天最后一笔不为空的数据。我写的这段程序返回的还是当天最后一笔。不知道哪里错了。
SELECT DateTime as DateTime,device as device, HK_40007 as P1, HK_40008 as P2,HK_40009 as P3 FROM wendu WHERE device='b1f1u1' AND HK_40007!='' AND HK_40008!='' AND HK_40009!='' AND DateTime>=CURDATE() AND DateTime<DATE_SUB(CURDATE(),INTERVAL -1 DAY) order by DateTime desc limit 1;

Answer 1

在你的where条件里加上判断 datetime<CURDATE();