How can count table column unique values in Laravel 5.6?

Question

working with laravel 5.6 and mysql. I have following table name as projects

id  name  type  
1   tuna  bio
2   nhye  IT
3   hyuj  bio
4   tour  IT
5   ghyt  commerce

I need count type column values which are unique values. as an example in above table I need count values 3 because there are three different values like bio, IT and commerce. how can I do this?

actually I need only count unique values. like `3` in above example — Muru, Dec 14 '18 at 11:45
Possible duplicate of [Laravel Distinct Count](https://stackoverflow.com/questions/35868551/laravel-distinct-count) — DEarTh, Dec 14 '18 at 12:19

score 2 · Accepted Answer · answered Dec 14 '18 at 12:12

2

Using Query builder

DB::table('projects')
        ->distinct()
        ->count('type');

answered Dec 14 '18 at 12:12

Prashant Deshmukh.....

2,244
1
9
11

score 1 · Answer 2 · answered Dec 14 '18 at 11:41

1

you can use this SQL query :

SELECT COUNT(DISTINCT type) as 'number total' FROM projects

The column 'number total' will be the number of differents value in your column 'type'

answered Dec 14 '18 at 11:41

Fizik26

753
2
10
25

I need use this on Laravel controller? – Muru Dec 14 '18 at 11:43
You have to use it in the file where your execute queries – Fizik26 Dec 14 '18 at 12:01

score 0 · Answer 3 · answered Dec 14 '18 at 11:48

you can either use 2 ways in order to get the correct answer.

select Count(distinct type) from Projects

OR

select type, count(1) from Projects group by type;

I have used the table name as laravel instead Project

$data = DB::table("projects")

    ->select(DB::raw("COUNT(1) as count_row"))

    ->groupBy(DB::raw("(type)"))

    ->get();

print_r($data);

How can count table column unique values in Laravel 5.6?

3 Answers3