php - how do i ignore the backticks in codeigniter when using active records? i need to order by cases

Question

how do i ignore the backticks in codeigniter when using active records? i need to order by cases

case when roll_number is null then 1 else 0 end,

which code igniter makes it as

ORDER BY `case` when roll_number is null then 1 else 0 end

which gives me an error. Please help

Answer 1

This could be a little old, but for someone who is looking for an answers you could add

$this->db->_protect_identifiers=false;

be aware that this will remove all backticks on this query