如何在laravel中查找数据库条目中的重复项

Question

我需要使用laravel.But在数据库条目中查找重复项，我的结果不正确，请帮助查找。

$query    =    DB::table('tbl_documents as td')
        ->leftjoin('tbl_document_types as tc','td.document_type_id','=','tc.document_type_id')
        //->leftjoin('tbl_documents_columns as tdc','td.document_id','=','tdc.document_id')
        ->leftjoin('tbl_departments as tdp','td.department_id','=','tdp.department_id')
        ->leftjoin('tbl_stacks as ts','ts.stack_id','=','td.stack_id')
        ->select('td.document_name','td.document_file_name','tc.document_type_id','td.document_type_id','td.stack_id','tdp.department_id')->havingRaw('count(*)>1')
        ->where('td.document_type_id',$doctypeid)
        ->get();

Answer 1

你应该试试这个

$results = DB::table('tbl_documents')->whereIn('document_file_name', function ( $query ) {
            $query->select('document_file_name')->from('tbl_documents')->groupBy('document_file_name')->havingRaw('count(*) > 1');
        })->get()->toArray();

return $results;