Laravel query. Where unique

Question

I got database table like this:

I want to write query, which could select only unique id's. By saying unique I mean select only these values once:
5, 6, 7, 8

Thanks in advance!

What code have you written to solve this problem? Please post your code and a (specific) problem. — Damien, Jun 08 '15 at 12:43
At the moment my query picks all the job_id's. So when I do echo, my values doublicate. I want to echo these job_id's only once. — Evaldas Butkus, Jun 08 '15 at 12:49

score 13 · Answer 1 · answered Jun 08 '15 at 12:58

13

You could use DISTINCT.

DB::table('table')->select('job_id')->distinct()->get();

answered Jun 08 '15 at 12:58

aebersold

wiesson · Accepted Answer · 2015-06-08T13:16:00.080

11

How about:

$jobs = DB::table('my_job_table')
    ->groupBy('job_id')
    ->get();

Eloquent:

First, you need a model. You could generate this by using php artisan. php artisan make:model jobs (I assume you have done this already) This will create a model in /your_project/app/Job.php
Now you can use Eloquent (here in a route, to see some output):

Route::get('/jobs', function () { $jobs = \App\Job::groupBy('job_id')->get(); return $jobs->lists('job_id'); });

will return something like: [0,1,3,4] instead of [0, 1, 1, 1, 3, 4, 4, 4].

edited Jun 08 '15 at 13:16

answered Jun 08 '15 at 12:31

wiesson

2 Answers2