CodeIgnitEE
Using CodeIgniter’s ActiveRecord to SELECT rows w/IS NOT NULL

How do you create something like this SQL using CodeIgniter’s ActiveRecord library:

SELECT*FROM tests WHERE test_id IS NOT NULL

Although the docs doesn’t mention this it’s pretty easy:

$ct = $this->db->get_where('tests', array(test_id !=' => 'NULL'));

  1. codeignitee posted this