mysql - 如何在 CodeIgniter 中添加不带引号的 null 条件？

Question

这段代码:

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

给予:

WHERE id_etablissement_commanditaire IS NULL

那个:

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

给予:

WHERE `id_etablissement_commanditaire` IS 'NULL'

有没有办法获得:

    WHERE `id_etablissement_commanditaire` IS NULL

即我想要反引号而不是引号。

Answer 1

尝试这样的事情:

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)
}