如何将下面的 SQL 语句转换为 Eloquent?
SELECT * FROM `messages` WHERE (`to`=$myID AND `from`=$guestID) OR (`to`=$guestID AND `from`=$myID)
【问题讨论】:
使用嵌套查询。我建议从 eloquent 和 query builder 文档开始 【参考方案1】:对parameter grouping 使用where
和orWhere
闭包:
Message::where(function($q) use($myId, $guestId)
$q->where('to', $myId)->where('from', $guestId);
)
->orWhere(function($q) use($myId, $guestId)
$q->where('to', $guestId)->where('from', $myId);
)
->get();
【讨论】: