Remove duplicate values

How to remove duplicate values while selecting from table in database.

[ { A: "test", B: "test1" }, { A: "test1", B: "test" }, { A: "test2", B: "test1" }, { A: "test2", B: "test" } ]

Level 75

You can use unique for that

$unique = $collection->unique(function ($item) {
    return $item->a . $item->b;
});

Level 1

I have tried it, it didn't work!

Level 75

Yeah, because it was just an example, I don't know what should be your output. Just change logic inside of that unique funtion.

Level 1

put your query here maybe every body can help.

Level 73

You can use distinct in your query.

SELECT DISTINCT name FROM books;

$users = DB::table('users')select('name')->distinct()->get();

Not able to test the eloquent version at the moment but I think it should work.

Level 104

What are the duplicates here? Duplicates of A, or duplicates of B, or duplicates of AB?

Please or to participate in this conversation.