tp5写sql语句

Question

怎样用tp5写出如下sql?

SELECT * FROM `student` WHERE `sex` = 1 AND ((`age` IN (10,11,12) 

AND `name` LIKE '%李%'） OR (`age` IN (15,16,17) AND `name` LIKE  '%长%'));

Answer 1

大概应该是这样子。

Student::where('sex', '=', 1)
  ->where(function($query){
    $query->where(function($query){
      $query->where('age' , 'in', [10,11,12])->where('name','like','%李%');
    })
      ->orWhere(function($query){
        $query->where('age', 'in', [15,16,17])->where('name', 'like', '%长%');
      })
    
  })

Answer 2

$sql = "SELECT * FROM `student` WHERE `sex` = 1 AND ((`age` IN (10,11,12) AND `name` LIKE '%李%'） OR (`age` IN (15,16,17) AND `name` LIKE  '%长%'));";
$list = Db::query($sql);