phpmysqlcodeigniteractiverecordnotin

Convert SELECT query with WHERE NOT IN (subquery) to CodeIgniter active record syntax

How to write this query in codeigniter format?

SELECT rights_management.id, rights_management.tab_name FROM rights_management 
WHERE rights_management.id NOT IN (SELECT r_m.tabid FROM r_m)
Solution

  • You can write your sub query in CI using where clause

    $this->db->select('rights_management.id, rights_management.tab_name');
$this->db->from('rights_management');
$this->db->where('`rights_management.id` NOT IN (SELECT r_m.tabid FROM `r_m`)', NULL, FALSE);