How to update row based on two condition using eloquent in Laravel?

Question

I have a table : Profile Table has one foreign key and primary key. I want to update row based on two condition . Like : where ( id == 1 and user == 'admin')

How to use two para meter in update query using eloquent.

Possible duplicate of [How to create multiple where clause query using Laravel Eloquent?](https://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent) — Devon Bessemer, Jul 02 '18 at 20:18

score 17 · Accepted Answer · edited Mar 31 '22 at 05:03

17

you can do this by make the following:

ModelName::where(['id'=>1,'user'=>'admin'])
->update(['column_name'=>'value',.....]);

edited Mar 31 '22 at 05:03

Mr. Perfectionist

2,605
2
24
35

answered Jul 02 '18 at 21:17

ali

832
6
11

getting error - `SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' ` – Kamlesh Jan 24 '23 at 11:24
Could you provide me with what you wrote ? – ali Jan 26 '23 at 06:11

score 0 · Answer 2 · answered Jul 03 '18 at 05:06

0

Try it

$obj=ModelName::where('id','=',1)->where('user','=','admin')->first();
if(count($obj) == 1){
   $obj->column_name=value;
   $obj->save();
}

answered Jul 03 '18 at 05:06

Narinder Bajwa

54
4

this just updates all rows with user = admin from my tests – qwertzman Oct 11 '19 at 19:13

How to update row based on two condition using eloquent in Laravel?

2 Answers2