Codeigniter Active Record - Delete where not in array

Question

I have found this codeigniter active record query where I can delete items in an array

$this->db->delete('stack', array('id' => $id))

However, I would like to delete items which are not in the array.

Is this possible.?

I don't have a chance to test it, but would that not work: $this->db->where_not_in('id', $ids); $this->db->delete('stack'); — Aidas
– Aidas, Commented Apr 1, 2014 at 15:36

Aidas · Accepted Answer · 2014-04-02 11:37:22Z

9

This should do the trick:

$this->db->where_not_in('id', $ids);
$this->db->delete('stack');

answered Apr 2, 2014 at 11:37

Aidas

1,2492 gold badges10 silver badges16 bronze badges

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

1 Answer 1