使用mysql函数查询时报错


原生sql:

SELECT id,WEEKDAY(DAY) AS wd,DATE_FORMAT(DAY,'%m-%d') AS dd

FROM sss

WHERE YEARWEEK(DATE_FORMAT(DAY,'%Y-%m-%d') - INTERVAL 1 DAY) = YEARWEEK(NOW() - INTERVAL 1 DAY)


我用laravel写的时候报错了。。。

 $res = DB::table('ss')

            ->select('id','WEEKDAY(DAY) AS wd',"DATE_FORMAT(DAY,'%m-%d') AS dd")

            ->where("YEARWEEK(DATE_FORMAT(DAY,'%Y-%m-%d') - INTERVAL 1 DAY)" , "YEARWEEK(NOW() - INTERVAL 1 DAY)")

            ->get();

报错信息
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'WEEKDAY(DAY)' in 'field list' (SQL: select `id`, `sid`, `WEEKDAY(DAY)` as `wd`, `DATE_FORMAT(DAY,'%m-%d')` as `dd`, `stepnum` from `sport_stepnum` where `YEARWEEK(DATE_FORMAT(DAY,'%Y-%m-%d') - INTERVAL 1 DAY)` = YEARWEEK(NOW() - INTERVAL 1 DAY) and `sid` is null)


想问

WEEKDAY(DAY) 被加上 反引号 “  `  ”,且date_format里面的参数乱码

laravel新手,求高手解答 谢谢!!!!!


点赞 取消点赞 收藏 取消收藏

<< 上一篇: laraval调用rar_open

>> 下一篇: update方法怎么把 一个字段的值更新为另一个字段