/PHP/Laravel increment column value in update query

Laravel increment column value in update query

DB::table('my_table')
   ->where('rowID', 1)
   ->update([
       'column1' => DB::raw('column1 + 2'),
       'column2' => DB::raw('column2 + 10'),
       'column3' => DB::raw('column3 + 13'),
       'column4' => DB::raw('column4 + 5'),
   ]);

Source: stackoverflow.com

Similar codes

0 vote170 views1 answer
How to filter the all special characters in cakephp from an array
PHP
0 vote145 views1 answer
Laravel mcq questions
PHP Laravel
4 votes128 views3 answers
Laravel view routes
PHP
9 votes151 views2 answers
Laravel query count raw
PHP Laravel
0 vote146 views1 answer
Can we use 2 select in a query laravel
PHP Laravel
0 vote139 views1 answer
Laravel nova resolveUsing
PHP Laravel
0 vote132 views1 answer
Define constructor in trait php
PHP
-2 votes126 views3 answers
Laravel create get id
PHP
0 vote132 views1 answer
Acf if image else display other image
PHP
0 vote148 views1 answer
Check if variable is set and not empty laravel
PHP Laravel