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

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.

dev_mustafa · Accepted Answer · 2021-04-13 16:38:37Z

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, 2021 at 16:38

dev_mustafa

1,1111 gold badge7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mail2bapi · Accepted Answer · 2021-04-13 16:42:37Z

0

Try this

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

For more information look here

answered Apr 13, 2021 at 16:42

mail2bapi

1,6171 gold badge15 silver badges19 bronze badges