Home / Questions / 275596
Accepted
elapez
Asked: 2020-06-30 10:21:18 +0800 CST 2020-06-30 10:21:18 +0800 CST

How to change with Eloquent ORM all the records of a single field in a query

  • 772

I would like to do something like this with Eloquent:

UPDATE `perros` SET `raza` = "indeterminado" WHERE `raza` = "Lobo"

So that all records in the "race" field that match the value "Wolf" are automatically rewritten to the value "indeterminate".

I know how to identify all records with the value "Lobo" but I don't know how to update them all at once.

Perros::where("raza","Lobo")->get()
laravel

1 Answers

  1. Best Answer

    For this the Update method of Eloquent is used

    Perros::where('raza', 'Lobo')->update(['raza' => 'indeterminado']);
    • 2