How do I filter my DB query results to not display any duplicate value

Question

I have a query like this:

$blog = BlogModel::select('user_id')->get();

and it return this

[{"user_id":2},{"user_id":3},{"user_id":4},{"user_id":4},{"user_id":6}]

I would like Delete duplicate user_id like this

[{"user_id":2},{"user_id":3},{"user_id":4},{"user_id":6}]

nbk · Accepted Answer · 2022-02-23 17:46:41Z

2

You can use DISTINCT for that purpose

$blog = BlogModel::select('user_id')->distinct()->get();

answered Feb 23, 2022 at 17:46

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jesús Noè Nogueiras · Accepted Answer · 2022-02-24 07:56:23Z

1

You can use distinct() to force the query to return distinct results.

Try change this:

$blog = BlogModel::select('user_id')->get();

To:

$blog = BlogModel::select('user_id')->distinct()->get();

answered Feb 23, 2022 at 17:52

694 bronze badges

Rabie · Accepted Answer · 2022-02-23 21:43:50Z

0

$blog = BlogModel::selectRaw('distinct user_id')->get();

answered Feb 23, 2022 at 21:43

Rabie

522 bronze badges