How to get updated instance about laravelbatch

[djunehor]

SQL update queries usually returns the rows affected, so the implementation is right in returning an array of updated rows.

You can easily do something like $userInstance->where('country', 'UK')->get(); which will return the up-to-date model instance

[dododaphne]

Thanks for replay. What if I don't want to get all up-to-date data. For example, if I have a table which contains 10 thousands users. I just updated 500 users, and I only want to get 'country' from 'UK' among the 500 users, how could I do?

[djunehor]

You can achieve that this way:

$ids = array_column($value, 'id');
$userInstance->whereIn('id', $ids)->where('country', 'UK')->get(); 

[dododaphne]

That’s a simple and clean solution, thank you very much!