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();
$this->db->from (tablename);
$this->db->where('columname',value);
$response=$this->db->get();
return $response->result();
How to use concat function in codeigniter 4 with orm model?
ReplyDelete