php - 需要帮助将 SQL 查询转换为 Laravel eloquent

Question

我有这个 SQL 查询:

SELECT * FROM `user` WHERE `id` IN(
    SELECT  DISTINCT if(`sender_id`='2',`receiver_id` ,`sender_id`) AS `id`
    FROM    `message`
    WHERE   (`receiver_id`  = '2' OR `sender_id` = '2')
    )

我需要转换为 Laravel eloquent。问题是，我不知道如何转换 IF 函数。

Answer 1

User::whereIn('id', Message::distinct()->select(DB::raw('if(sender_id=2, receiver_id, sender_id) as id'))->where( 
            function( $query ) {
                $query
                ->where('receiver_id', 2)
                ->orWhere('sender_id', '2');
            }
        ))->toSql();

要在sql语句中使用if条件，您可以使用DB::raw方法:)