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
– hayumi kuran

2018-08-29 04:01:23 +00:00
Commented Aug 29, 2018 at 4:01 — hayumi kuran
– hayumi kuran, Commented Aug 29, 2018 at 4:01

Dhruv Raval · Accepted Answer · 2018-08-29 03:58:28Z

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, 2018 at 3:58

Dhruv Raval

1,5831 gold badge10 silver badges18 bronze badges

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

1 Comment

hayumi kuran Over a year ago

That's what i want, tks so much!

Jonas Staudenmeir · Accepted Answer · 2018-08-29 03:56:34Z

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, 2018 at 3:56

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

4 Comments

hayumi kuran Over a year ago

'decrement' clause is what i want, but like @dhruv's answer, it must be decrement('sort_no', 1). Anw, tks so much

Jonas Staudenmeir Over a year ago

decrement('sort_no') is enough, the default $amount is 1.

hayumi kuran Over a year ago

oh yes, that's true, sorry for my mistake

Dhruv Raval Over a year ago

yes 1 is default value. but for your understanding i pass 1. you can change 2nd value as per your requirement

Collectives™ on Stack Overflow

Laravel: Update multiple rows in one query

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related