Question : select query in ci
Answered by : nipun-agarwal
$this->db->select('username') ->from('user') ->where('`locationId` in', '(select `locationId` from `locations` where `countryId` = '.$countryId.')', false) ->get();
Source : | Last Update : Sat, 21 Aug 21