How to add a null condition in CodeIgniter without quotes?

Question

This code:

$this->db->where('id_etablissement_commanditaire IS ', $_POST['id_etablissement_commanditaire'], FALSE  );

Gives:

WHERE id_etablissement_commanditaire IS NULL

That one:

$this->db->where('id_etablissement_commanditaire IS ', $_POST['id_etablissement_commanditaire']);

Gives:

WHERE `id_etablissement_commanditaire` IS 'NULL'

Is there a way to get :

    WHERE `id_etablissement_commanditaire` IS NULL

I.e. I would like backticks but not quotes.

Answer 1

Try something like this:

if ($_POST['id_etablissement_commanditaire']) {
    $this->db->where('id_etablissement_commanditaire IS ', $_POST['id_etablissement_commanditaire']);
} else {
    $this->db->where('id_etablissement_commanditaire IS NULL', null, false)
}