Update with limit 1 in codeigniter use active record

Question

I'm trying to update a single record with the active record of codeigniter and it still fails.

$data = array('status' => 1);

$this->db->where('field1', $info);
$this->db->update('example', $data);
$this->db->limit(1);

When i run updates all fields of the database. By making a $ this->db->last_query() does not show me the limit

What is the error

Answer 1

Move the limit before the update which should be always called last:

$this->db->limit(1);
$this->db->update('example', $data);