Current Location: Home> Latest Articles> How to Batch Update Multiple Records in Laravel: Achieve Efficient Data Operations

How to Batch Update Multiple Records in Laravel: Achieve Efficient Data Operations

gitbox 2025-07-14

Introduction

Laravel is an excellent PHP framework that offers many powerful features and tools. In actual development, we often encounter situations where we need to update multiple records simultaneously. If the number of records to update is large, updating each one individually can be very tedious and inefficient. In such cases, Laravel's batch update functionality allows you to update multiple records at once, improving code execution efficiency. This article will introduce how to batch update multiple records in Laravel.

Batch Update Multiple Records

In Laravel, you can easily batch update multiple records using the update method provided by Eloquent. Eloquent is the most commonly used ORM (Object-Relational Mapping) tool in Laravel, making database operations simpler and more understandable.

You can perform a batch update with Eloquent's update method like this:

Model::where('condition')->update(['field' => 'value']);

In this example, `Model` is the target model, the `where` method is used to filter records that meet the condition, the `update` method updates these records, and `['field' => 'value']` represents the field and its new value to be updated.

For instance, let's say we have a table called `users`, with fields for ID, name, and age. If we want to update the age of all users older than 30 to 40, we can use the following code:

$affected_rows = User::where('age', '>', 30)->update(['age' => 40]);

This code will update the age of all users older than 30 in the `users` table to 40 and return the number of affected rows.

Batch Update Example

Next, let's look at a more concrete batch update example:

Assume we have a table called `messages` with the following fields:

  • id: Message ID
  • content: Message content
  • created_at: Creation timestamp
  • updated_at: Update timestamp

Now, suppose we want to replace the word 'hello' with 'world' in all message contents in the `messages` table. We can do this with the following code:

$affected_rows = Message::where('content', 'like', '%hello%')->update(['content' => DB::raw("REPLACE(content, 'hello', 'world')")]);

In this example, we use `where('content', 'like', '%hello%')` to filter messages containing 'hello'. Then, we use `update(['content' => DB::raw("REPLACE(content, 'hello', 'world')")])` to replace 'hello' with 'world' in the content. The `DB::raw` method is used here to ensure the `REPLACE` function in the SQL query executes properly. This method will return the number of affected rows, which represents the number of records updated.

Conclusion

This article introduced how to batch update multiple records in Laravel. By using Eloquent's `update` method and `DB::raw`, we can efficiently update multiple records in the database, improving code execution efficiency. Once you master these techniques, you can optimize your database operations when dealing with large datasets and enhance system performance.

Related