[Laravel] And/Or複合検索 – 端くれプログラマの備忘録

AND検索

$query->where('column1', '=', $value1)->where('column2', '=', $value2);

1	$query->where('column1', '=', $value1)->where('column2', '=', $value2);

OR検索

$query->where('column1', '=', $value1)->orWhere('column2', '=', $value2);

1	$query->where('column1', '=', $value1)->orWhere('column2', '=', $value2);

複合検索 (A or B) and (C or D)

$query->where(function($query) use($value1, $value2){
    $query->where('column1', '=', $value1)->orWhere('column2', '=', $value2)
});
$query->where(function($query) use($value3, $value4){
    $query->where('column1', '=', $value3)->orWhere('column2', '=', $value4)
});

$query->where(function($query) use($value1, $value2){

$query->where('column1', '=', $value1)->orWhere('column2', '=', $value2)

});

$query->where(function($query) use($value3, $value4){

$query->where('column1', '=', $value3)->orWhere('column2', '=', $value4)

});

Eloquent/QueryBuilderによるAnd検索とOr検索の複合 – Laravel5開発
https://umebius.com/laravel/querybuilder%E3%81%AB%E3%82%88%E3%82%8Band%E6%A4%9C%E7%B4%A2%E3%81%A8or%E6%A4%9C%E7%B4%A2%E3%81%AE%E8%A4%87%E5%90%88/

関連記事