Update query increment field plus 1 codeigniter

Name: Redmi Y2 Tech Review
Uploaded: 2018-08-05 T20:00:00+05:30
Duration: 6 min 59 s
Description: Namasty dosto is video maine Xiaom Redmi Y2 bare mein baat krunga, or sath hi Redmi Y2 ke kuch key features aapke sath share krunga. 1. Dual 12MP + 5MP cameras width Precise bokeh effect. 2. 16MP front camera width 4500K soft-toned light.

how would I go about updating that field by 1 within a sql command?

Ankur Rajput

Asked 12-07-2024

237

Answer (1)

$this->db->where("id", $id);
$this->db->set("set_row", "`set_row`+ 1", FALSE);
$this->db->update("article");

Deepak Sharma

Asked 18-07-2018

45 Likes

Comments

Write comment

Submit your answer