php - 按子句顺序计算两列的总和 - laravel

Question

我正在尝试将以下 mysql 查询转换为等效的 laravel。

select email from emails 
order by call_count + receive_count desc;

到 Laravel

DB::table('emails')
->select('email')
->orderBy(SUM('call_count','receive_count'), 'DESC')
->get();

请告诉我..谢谢

Answer 1

试试这个

DB::table('emails')
    ->select('email')
    ->orderBy(DB::raw("`call_count` + `receive_count`"), 'desc')
    ->get();