In my MySQL to select between data

 Example:

SELECT id, current_role_in_khmer
FROM currentrole
WHERE id  NOT BETWEEN 11 AND 14
AND id  NOT BETWEEN 18 AND 19
AND `status`=1


in codeigniter

      $this->db->select('*');
      $this->db->from('currentrole');
      $this->db->where('status', '1');
      $this->db->where('id !=',1 );
      $this->db->where("id BETWEEN 2 and 4");
      $data['get_currentrole_leader']=$this->db->get()->result();