mysql - 拉维尔 5 : whereRaw escapes integer to string

Question

Laravel 对此的 Eloquent 查询是什么:

select * from `jobs` where (
      400000 between min_salary and max_salary
            or
      600000 between min_salary and max_salary
 );

我尝试了以下 Eloquent 查询，它将整数封装为字符串

$min = 400000;
$max = 600000;
Job::whereRaw('
     ? between min_salary and max_salary
        or
     ? between min_salary and max_salary',
     [$min,$max]
)->get();

还尝试了 Casting 和 DB::Raw，所有选项都没有按预期工作。

protected $casts = [
    'min_salary' => 'integer',
    'max_salary' => 'integer',
];

$min = 400000;
$max = 600000;
Job::whereRaw('
     ? between min_salary and max_salary
        or
     ? between min_salary and max_salary',
     [DB::Raw($min),DB::Raw($max)]
)->get();

我尝试了下面的 Eloquent 查询，但我直接对查询进行了硬编码(不安全)

$min = 400000;
$max = 600000;
Job::whereRaw(
   $min.' between min_salary and max_salary 
     or
   '.$max.' between min_salary and max_salary'
)->get();

Answer 1

试试这个:

Job::where(function($query){
    $query->where('min_salary','<',400000);
    $query->where('max_salary','>',400000);
})->orWhere(function($query){
    $query->where('min_salary','<',600000);
    $query->where('max_salary','>',600000);
})->get();