下面是我使用mysql命令编写的代码
SELECT * FROM `order_list` WHERE currentdate like '%12%' and currentdate like '%2017%'但我很难把它变成拉拉雄辩。
$orderlists = Orderlist::where('currentdate', 'like', "%$month%")
->where('currentdate', 'like', "%$year%")
->get();对吗?谢谢
发布于 2017-11-28 09:26:25
$orderlists = Orderlist::whereMonth('currentdate', 'LIKE','%'.$month.'%')
->whereYear('currentdate', 'LIKE', '%'.$year.'%')
->get();发布于 2017-11-28 09:20:11
您还可以使用原始sql查询,如下所示
$orderlists = DB::select("SELECT * FROM `order_list` WHERE currentdate like '%12%' and currentdate like '%2017%'");https://stackoverflow.com/questions/47527652
复制相似问题