laravel 查询语句中有括号的情况下处理
举例一下语句:
select * from users where id < 12 and ( name like '%z' or email like '163@%')
在 laravel 中使用查询构建器应该使用闭包的方式进行实现 如下:
<?php
namespace App\Admin\Controllers;
use App\Http\Controllers\Controller;
use Illuminate\Database\Query\Builder;
use Illuminate\Support\Facades\DB;
class TestController extends Controller
{
public function test(){
$users = DB::table('users')->where('id','<', 12)->where(function(Builder $query){
$query->where('name','like','%z')->orWhere('email','like', '163@%');
})->get();
dump($users);
}
}