Select fields that have a property set to null with codeigniter query

Question

I am trying to create the following statement:

$this->db->where('uu.usuario_grupo_id is null');

But it doesn't work

I also tried this:

$this->db->where('uu.usuario_grupo_id =', null);

$this->db->where('uu.usuario_grupo_id =', 'null');

none of these options returns data from fields referenced as null.

https://stackoverflow.com/a/13995884/2275490 – Vickel Apr 13 '21 at 16:41 — Vickel, Apr 13 '21 at 16:41

score 0 · Answer 1 · answered Apr 13 '21 at 16:38

0

You can do it as below:

$this->db->where(array('uu.usuario_grupo_id' => NULL));

produces

WHERE `usuario_grupo_id` IS NULL

answered Apr 13 '21 at 16:38

dev_mustafa

score 0 · Answer 2 · answered Apr 13 '21 at 16:42

0

Try this

$this->db->where('uu.usuario_grupo_id IS NULL', null, false);

For more information look here

answered Apr 13 '21 at 16:42

mail2bapi

2 Answers2