is null in mysql codeigniter code example
Example 1: codeigniter query builder where not null
$this->db->where('field is NOT NULL', NULL, FALSE);
Example 2: where not null query codeigniter
$this->db->where('columnName !=', null);
$this->db->where('field is NOT NULL', NULL, FALSE);
$this->db->where('columnName !=', null);