Update multiple records using Eloquent

ItemTable::where('item_type_id', '=', 1)
->update(['colour' => 'black']);

ItemTable::where('item_type_id', '=', 1)->update(['color' => 'black']);

perfect thanks guys :)

Hi guys, These too works..

$values=array('column1'=>'value','column2'=>'value2');
ItemTable::whereIn('primary_key','value')->update($values);

Note: whereIn() is used for arrays..

What if you want to update multiple columns in a row?

@renz18x to update multiple columns

ItemTable::where('item_type_id', '=', 1)
    ->update([
        'colour' => 'black',
        'size' => 'XL', 
        'price' => 10000 // Add as many as you need
    ]);

or with whereIn()

$itemTypes = [1, 2, 3, 4, 5];

ItemTable::whereIn('item_type_id', $itemTypes)
    ->update([
        'colour' => 'black',
        'size' => 'XL', 
        'price' => 10000 // Add as many as you need
    ]);

I know this thread was created 3yrs ago. But Im trying to update multiple rows when a user sends an array of id. eg user send me array of applicant id's [3,4,5,6] then I update a boolean column called "isStarred" to 1 for all those applicants. Thanks in advance

Bear in mind that these are "bulk" methods and so won't fire model events!

I think this should do the trick:

User::whereIn('id', $applicant_ids)
    ->update([
        'IsStarred' =>  1,
    ]);

Update Specific column you want to upadate using Laravel eloquent.

Way -> 1

[Status-> Column you want to update]

Model::where('status', '=', 1)->update(['status' => 0]);

$updateStatus = new Model();

$updateStatus->status = $request->input('status');

$updateStatus->save();

Way -> 2

[Status-> Column you want to update]

$allData = Model::where('status', 1)->get();

            foreach ($allData as $data){
                $data->status = 0;

                $data->update();

			}

$updateStatus = new Model();

$updateStatus->status = $request->input('status');

$updateStatus->save();

Sorry for the convenience for not using codeblocks