Ronny-André Bendiksen Ronny-André Bendiksen - 1 year ago 202
SQL Question

Querying MySQL with CodeIgniter, selecting rows where field is NULL

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');

That only returns this query:

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

field is a

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

Answer Source
where('archived IS NOT NULL', null, false)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download