How to find duplicate values in database with Laravel

Question

How can I find duplicate values in database with Laravel. I want the results like this:

name_data - amount

(Column name along with amount of duplicate data)

I used this code but it didn't work:

$duplicates = DB::table('jadwals')
    ->select('nama_peserta', (DB::raw('COUNT(nama_peserta)')))
    ->groupBy('nama_peserta')
    ->having(DB::raw('COUNT(nama_peserta)  > 1'))
    ->get();

Please help me, thank you!

I would rewrite ->select('nama_peserta', (DB::raw('COUNT(nama_peserta)'))) to ->selectRaw('nama_peserta, COUNT(nama_peserta)') — thephper
– thephper, Commented Mar 10, 2020 at 9:07

TsaiKoga · Accepted Answer · 2020-03-10 09:08:31Z

2

You have a syntax error with having DB::raw(), try:

->having(DB::raw('COUNT(nama_peserta)'), '>', 1)

or

->havingRaw('COUNT(nama_peserta) > 1')

answered Mar 10, 2020 at 9:08

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

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

1 Comment

Gagang Over a year ago

Yes, you're right, my code is finally running. Thankyou so much @TsaiKoga

Collectives™ on Stack Overflow

How to find duplicate values in database with Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related