Problems with unique records laravel 5.5

Question

Problems with unique records laravel 5.5

Navigation

#1 by (1 votes)

2

Since I have had problems with the plunk() method I have tried to find a way to translate this query to Eloquent, but until now I have not succeeded, is there any other way?

select distinct usuario_ad from usuarios;

laravel-5

asked by zereft 15.12.2018 в 22:57

source

1 answer

Laravel redirects in a controller How to automatically pause an audio in java netbeans?

score 1 · Accepted Answer

Your query should occupy the distinct () method, but you can also use the raw () method to write the method in sql.

With Eloquent Laravel:

$data = User::select("usuario_ad")
            ->distinct()
            ->get();

Or with the query builder

$data = \DB::table("usuarios")
           ->select("usuario_ad")
           ->distinct()
           ->get();