Laravel: How to update all rows in table

Recently I had to update all Laravel Eloquent model objects with the same values at once. While updating each object one by one is a possibility, it's terribly inefficient and not recommended.

This article outlines how you can set every row with the same values using Laravel's Eloquent.

The efficient way (use this)

Product::query()->update([
	'stock' => 0,
	'status' => 'private',
]);

The query above results, when prepared, in the following SQL statement:

UPDATE `products` SET `stock` = 0, `status` = 'private'

This is exactly what we want. Just a single statement, your database handles the rest.

The inefficient way (don't use this)

This is inefficient, because it first queries all objects from your database, stores them in memory, assigns the objects to a variable one by one and updates them one by one. When you have a large database, it consumes lots of memory, and costs many database queries.

foreach (Product::all() as $product) {
	$product->update([
    	'stock' => 0,
      	'status' => 'private',
    ]);
}

Bonus: adding WHERE clauses

If you also want to add WHERE clauses to filter specific rows, use this:

// Update all products with status 'publish' or status 'unlisted'
Product::whereIn('status', ['publish', 'unlisted'])
    ->update([
        'stock' => 0,
        'status' => 'private',
    ]);