How to write: WHERE [field] IS NULL

[dreammonkey]

Works:
$this->db->where('field IS NULL');
$result = $this->get_all();

DOES NOT WORK:
$result = $this->where('field', NULL)->get_all();
$result = $this->where('field is', NULL)->get_all();
$result = $this->where('field IS NULL')->get_all();
$result = $this->get_all('field is null');

[salain]

You need to make the where clause a custom string like this:

$result = $this->where('fieldName IS NULL',NULL,NULL,FALSE,FALSE,TRUE)->get_all();

[nuryagdym]

it causing serious problem, and generated headaches to me
described here #295