Use concat function in codeigniter select query
$this->db->select(' *,CONCAT(coloumname,couloumname2) as alias_name ',FALSE); $this->db->from (tablename); $this->db->where('columname',value); $response=$this->db->get(); return $response->result();
Comments
Post a Comment