Count in update query doesn't work in Laravel

Question

public function increment($id) { $this->model->where("id",'=', $id)->update(['rating'=> DB::raw('count+1')]); }

I am getting the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'count' in 'field list' (SQL: update news set rating = count+1, updated_at = 2019-04-13 08:12:51 where id = 5)

I also tried

->update(['rating'=>'count+1']);

nakov · Accepted Answer · 2019-04-13 09:14:30Z

3

You are not telling the query builder on which table you are performing the query, so DB::raw('count+1') makes no sense.

You can try to use the eloquent increment method like this:

$this->model->where("id", $id)->increment('rating');

Thanks @Tharaka removed the extra call to save().

edited Apr 13, 2019 at 9:14

answered Apr 13, 2019 at 8:41

nakov

14.4k14 gold badges74 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

emas94 Over a year ago

hah i tried it last time but i made stupid mistake, thank you for this, it work. But in last line must be update(). Thanks

Tharaka Dilshan Over a year ago

and, you don't have to call save(). it automatically saves to the database.

Collectives™ on Stack Overflow

Count in update query doesn't work in Laravel

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related