CodeIgniter: Case in where clause CodeIgniter: Case in where clause codeigniter codeigniter

CodeIgniter: Case in where clause


You can write your condition in where clause

$this->db->select("*");$this->db->where("idx",5342);$this->db->where("CASE WHEN reserve_date = 20151130 THEN reserve_time > 1537 ELSE reserve_date > 20151130 END");$query=$this->db->get("table");