Level 75
Use distinct for that
https://laravel.com/docs/8.x/queries#specifying-a-select-clause
But you need to get id as well, in that case use groupBy
->groupBy('title', 'content')
May 14, 2021
3
Level 1
Ignore Duplicate Rows on Eloquent Query
Hey there, I have a Posts Table, where the Titles of the Posts can be the same. Iwant to query my Posts Table so that it only returns one element for each duplicate row.
Example: id: Titles: Content: 1 Test1 some message 2 Test2 some message 3 Test1 some message 4 Test3 some message
My desired result: 1 Test1 some message 2 Test2 some message 4 Test3 some message
It doesnt matter which one gets ignored, I just want to have each Title being unique in the Query Result.
Level 73
So if your title looks like this
- Title 1
- Title 2
- Title2
- Title 3
You want the following result?
- Title 1
- Title 2
- Title 3
Level 1
yes exactly
Please or to participate in this conversation.