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

Question

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- gt db- gt where  archived       NULL     q    this- gt db- gt 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

User · Accepted Answer

where  archived IS NOT NULL   null  false

User · Answer

And just to give you yet another option  you can use NOT ISNULL archived  as your WHERE filter

User · Answer

this- db- or where  end date IS    NULL   false

User · Answer

Null must not be set to string      this- gt db- gt where  archived IS NOT   null     It works properly when null is not wrapped into quotes

User · Answer

You can do  if you want to test NULL    this- gt db- gt where exec  archived IS NULL     If you want to test NOT NULL    this- gt db- gt where exec  archived IS NOT NULL

User · Answer

Codeigniter generates an  IS NULL  query by just leaving the call with no parameters    this- gt db- gt where  column      The generated query is   WHERE  column  IS NULL

User · Answer

The Active Record definitely has some quirks  When you pass an array to the  this- gt db- gt where   function it will generate an IS NULL  For example    this- gt db- gt where array  archived    gt  NULL      produces   WHERE  archived  IS NULL    The quirk is that there is no equivalent for the negative IS NOT NULL  There is  however  a way to do it that produces the correct result and still escapes the statement    this- gt db- gt where  archived IS NOT NULL      produces  WHERE  archived  IS NOT NULL

User · Answer

One way to check either column is null or not is   this- gt db- gt where  archived   gt  TRUE    q    this- gt db- gt get  projects      in php if column has data  it can be represent as True otherwise False To use multiple comparison in where command and to check if column data is not null   do it like   here is the complete example how I am filter  columns in where clause  Codeignitor   The last one show Not NULL Compression   where   array  somebit    gt   1    status    gt   Published    archived     gt  TRUE     this- gt db- gt where  where

User · Answer

CodeIgniter 3  Only    this- gt db- gt where  archived IS NOT NULL      The generated query is   WHERE archived IS NOT NULL        this- db- where  archived IS NOT NULL  null false     lt  lt  Not necessary   Inverse    this- gt db- gt where  archived      The generated query is   WHERE archived IS NULL

User · Answer

Much better to use following   For is not null    where  archived IS NOT NULL   null     For is null   where  archived   null

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

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to activerecord

Examples related to null