php - 如何将此 MySQL 查询转换为等效的 Laravel 5.4 Elequent/查询生成器查询？

Question

SELECT `id` FROM `jobs` WHERE `job_type` IN ( 'topemployercheckbox1','topemployercheckbox2') OR `job_category` IN ( 'Contract','Intern') ;

<小时/>

我需要将此 MySQL 查询转换为 laravel 5.4 查询生成器查询。

Answer 1

你可以做到

ModelName::whereIn('job_type',['topemployercheckbox1','topemployercheckbox2'])
    ->orwhere(function($q){
          $q->whereIn('job_category',['Contract','Intern'])
})->get('id');

或

ModelName::whereIn('job_type',['topemployercheckbox1','topemployercheckbox2'])
    ->whereIn('job_category',['Contract','Intern'],'or')->get('id');