mysql - Eloquent 查询生成器 whereDate 抛出错误 : Unknown column '2017-05-03 12:00:00' in 'where clause'

Question

谁能告诉我这个查询有什么问题？

$orderdaytimes = OrderDayTime::whereColumn([
                    ['date','>=',$start],
                    ['date','<=',$end]
                 ]) -> get();

它给我错误:

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2017-05-03 12:00:00' in 'where clause' (SQL: select * from order_day_times where (date >= 2017-05-03 12:00:00 and date <= 2017-05-31 12:00:00))

我直接在 DB 中对其进行了测试，结果如下:

select * from `order_day_times` where (`date` >= '2017-05-03 12:00:00' and `date` <= '2017-05-31 12:00:00') 

但是 Eloquent 会自动在查询中添加“`”？ T_T

提前致谢。

Answer 1

只需将 whereColumn 替换为 where:

$orderdaytimes = OrderDayTime::where([
    ['date','>=',$start],
    ['date','<=',$end]
]) -> get();

whereColumn 方法可用于验证两列是否相等。 where 方法只是向您的查询添加一个 WHERE 子句，这就是您想要的。

https://laravel.com/docs/5.4/queries#where-clauses的最后一段:

You may also pass an array of conditions to the where function:

$users = DB::table('users')->where([ ['status', '=', '1'], ['subscribed', '<>', '1'], ])->get();