mysql - Laravel 查询生成器高级 wheres AND, OR

Question

 $query = new TableA;
 $query = $query->join('tableB', 'tableA.b_id', '=', 'tableB.id');
 $query = $query->where('tableB.something', '=', '1');
 $query = $query->where('tableA.something_else', '=', '2');

它产生:

 WHERE something=1 AND something_else=2 AND .. AND....

但是现在 - 我需要这个:

 WHERE something=1 AND something_else=2 AND (city=city1 OR city=city2 OR city=city3) AND (country=country1 OR country=country2)

有什么想法吗？

Answer 1

利用Advanced Wheres .对于您的示例，它将是这样的:

    ->where(function ($query) {
       $query->where('city', '=', city1)
             ->orWhere('city', '=', city2)
             ->orWhere('city', '=', city3);
    })->where(function ($query) {
       $query->where('country', '=', country1)
             ->orWhere('country', '=', country2);
    });