I need to update all of the rows in a database so that a particular field in all of them is equal to a single value. Here's an example.
假设我的数据库表是这样的:
id | data | confirmed |
---|---|---|
1 | someData | 0 |
2 | someData | 1 |
3 | someData | 0 |
I want to perform a query that sets the confirmed field of every row to 1.
我可以这样做:
$rows = MyModel::where('confirmed', '=', '0')->get();
foreach($rows as $row) {
$row->confirmed = 0;
$row->save();
}
但似乎还有更好的办法?一个查询只会说"将每行的‘确认’字段设置为1."
Does such a query exist in Laravel's Eloquent/Fluent?