php - 通过查询生成器对两列求和

Question

如何在codeigniter中添加数字？下面的代码

$this->db->where(array('is_active' => 1, 'time + duration <=' => time()));
$this->db->update('table', array('is_active' => 0));

将导致:

UPDATE `table` SET `is_active` = 0 WHERE `is_active` = 1 AND `time +` `duration` <= 1436170717

我想要

`time` + `duration`

Answer 1

我在它们之间添加了引号，它起作用了。

$this->db->where(array('is_active' => 1, '\'time\' + \'duration\' <=' => time() ));