mysql - Eloquent : "WHERE (equals statement) AND (LIKE statement)"

Question

我基本上想做的是:

select * from request where id = 1 and created_at like (today's date);

但使用 Eloquent 。

我试过:

 $query = m_requests::where(['id' => Auth::User()->id, "created_at", "like", "%".date("Y-m-d")."%"]);

但这会返回错误:

SQLSTATE[42S22]: Column not found: 1054 Unknown
column '0' in 'where clause' (SQL: select * from
from `request` where (`id` = 1 and `0` = created_at 
and `1` = like and `2` = %2016-04-22%))

有谁知道我怎样才能实现我想要做的事情？

总结:我希望 id 等于请求的 id，但我希望日期是“LIKE”今天的日期(这是因为我只对创建日期而不是创建时间感兴趣)。

干杯

Answer 1

试试这个，它应该工作:

m_requests::where('id', '=', Auth::user()->id)
            ->where('created_at', 'LIKE', '%'.date("Y-m-d").'%');