Laravel: Update multiple rows in one query

Question

How can i update multiple rows use laravel eloquent?

I want something like:

$guest = GuestJointDetail::where('guest_joint_id', $guest_joint_id)
    ->where('sort_no', '>', $sort_no)
    ->whereNull('deleted_at');

$guest->update(['sort_no' => DB::raw('sort_no - 1')]);

I have tried

$guest->update(['sort_no' => 10]);

and i worked!
So i think my problem is in DB::raw

Thank you so much!

@DhruvRaval: yes, that's why i don't know how – hayumi kuran Aug 29 '18 at 04:01 — hayumi kuran, Aug 29 '18 at 04:01

score 2 · Answer 1 · answered Aug 29 '18 at 03:58

2

use decrement();

guest = GuestJointDetail::where('guest_joint_id', $guest_joint_id)
    ->where('sort_no', '>', $sort_no)
    ->whereNull('deleted_at')
    ->decrement('sort_no',1);

use whereIn for multiple Ids:

guest = GuestJointDetail::whereIn('guest_joint_id', $guest_id_array)
        ->where('sort_no', '>', $sort_no)
        ->whereNull('deleted_at')
        ->decrement('sort_no',1);

answered Aug 29 '18 at 03:58

Dhruv Raval

1,535
1
8
15

That's what i want, tks so much! – hayumi kuran Aug 29 '18 at 04:19

score 1 · Accepted Answer · answered Aug 29 '18 at 03:56

1

You can use decrement():

$guest = GuestJointDetail::where('guest_joint_id', $guest_joint_id)
    ->where('sort_no', '>', $sort_no)
    ->whereNull('deleted_at')
    ->decrement('sort_no');

answered Aug 29 '18 at 03:56

Jonas Staudenmeir

24,815
6
63
109

'decrement' clause is what i want, but like @dhruv's answer, it must be decrement('sort_no', 1). Anw, tks so much – hayumi kuran Aug 29 '18 at 04:20
`decrement('sort_no')` is enough, the default `$amount` is `1`. – Jonas Staudenmeir Aug 29 '18 at 04:22
oh yes, that's true, sorry for my mistake – hayumi kuran Aug 29 '18 at 04:33
yes 1 is default value. but for your understanding i pass 1. you can change 2nd value as per your requirement – Dhruv Raval Aug 29 '18 at 04:46

Laravel: Update multiple rows in one query

2 Answers2