我的查询语句如下:
但是,结果看起来像这样:
SELECT * FROM message WHERE (seller_id = 1 OR buyer_id = 3) AND deleted_by NOT LIKE '%1%'
我希望将它转化为 Laravel Eloquent。
我尝试了如下方式:
Message::where('seller_id', auth()->user()->id)
->orWhere('buyer_id', auth()->user()->id)
->where('deleted_by', 'not like', '%'.auth()->user()->id.'%')
->get();
但是,结果看起来像这样:
SELECT * FROM message WHERE seller_id = 1 OR buyer_id = 3 AND deleted_by NOT LIKE '%1%'
似乎需要括号
我如何在Laravel Eloquent中添加括号?