mysql 查看函数 报错_使用mysql函数查询时报错

使用mysql函数查询时报错

由 DantesMee 创建于2年前, 最后更新于 2年前

版本号 #1

1697 views

0 likes

0 collects

原生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新手，求高手解答 谢谢！！！！！