Laravel 如何同时查询字段种不同的值
如何查询 同字段中不同的值,并且同时输出,图下查询出现多个角色重复,我想只显示一个名字,查询出来的值输入到一行表格中
$boss = DB::connection('MuOnline')->table('MEMB_INFO')
->leftJoin('Character', 'MEMB_INFO.memb___id', '=','Character.AccountID' )
->leftJoin('C_Monster_KillCount', 'Character.Name', '=', 'C_Monster_KillCount.name')
->select('C_Monster_KillCount.name', 'C_Monster_KillCount.MonsterId', 'C_Monster_KillCount.count', 'Character.Class')
->whereIn('MEMB_INFO.server_code', @$serverCode)
->whereIn('Character.Class', $classCode)
->where(function ($query) {
$query->orWhere('C_Monster_KillCount.name', 'like', '%' . @$_GET['search'] . '%');
})
->paginate(50)
->withPath('?serverCode=' . $_GET['serverCode'] . '&type=boss&class=' . @$_GET['class'] . '&search=' . @$_GET['search'] . '');
推荐文章: