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

php mysql codeigniter activerecord null
rebellion picture rebellion · Mar 22, 2010 · Viewed 114k times · Source

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

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.

Answer

zerkms picture zerkms · Mar 22, 2010 
where('archived IS NOT NULL', null, false)

Related questions

CodeIgniter : how to write where_in OR where_in query?

I'm using codeigniter to query a database, and I need to conditionally compare arrays in the where clause. So basically I want to do: where_in OR where_in depending on what array has data in it. So I will …

Read More
Codeigniter combine where_in and like active record queries

I have the following active record query: $this->db->select('id, email, first_name, last_name, current_location_state, current_location, avatar, avatar_fb'); $this->db->from('users'); $this->db->like('first_name', $search); $…

Read More
CodeIgniter: Unable to connect to your database server using the provided settings Error Message

I have been using CI just fine using the MySQL driver. I want to use the MySQL driver instead, but as soon as I change it (just add the ‘i’ at the end of MySQL, and added the port number) …

Read More