I'm using CodeIgniter's Active Record class to query the MySQL database. I need to select the rows in a table where a field is not set to NULL: That only returns this query: The archived field is a DATE field. Is there a better way to solve this? I know I can just write the query myself, but I want

How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?

I’m using CodeIgniter’s Active Record class to query the MySQL database. I need to select the rows in a table where a field is not set to NULL:

$this->db->where('archived !=', 'NULL');
$q = $this->db->get('projects');

JavaScript
​x
 
$this->db->where('archived !=', 'NULL');$q = $this->db->get('projects');​

That only returns this query:

SELECT * FROM projects WHERE archived != 'NULL';

JavaScript
 
SELECT * FROM projects WHERE archived != 'NULL';​

The archived field is a DATE field.

Is there a better way to solve this? I know I can just write the query myself, but I want to stick with the Active Record throughout my code.

where('archived IS NOT NULL', null, false)

JavaScript
 
where('archived IS NOT NULL', null, false)​