title: How to select rows where column value IS NOT NULL using CodeIgniter's ActiveRecord?
body: <p>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:</p>
  
  <pre><code>$this-&gt;db-&gt;where('archived !=', 'NULL');
  $q = $this-&gt;db-&gt;get('projects');
  </code></pre>
  
  <p>That only returns this query:</p>
  
  <pre><code>SELECT * FROM projects WHERE archived != 'NULL';
  </code></pre>
  
  <p>The <code>archived</code> field is a <code>DATE</code> field.</p>
  
  <p>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.</p>