Answered by : poor-peacock-j635r4syd822

 $sql="Select * from my_table where 1"; $query = $this->db->query($SQL); return $query->result_array();

Source : https://stackoverflow.com/questions/16435390/how-to-execute-my-sql-query-in-codeigniter | Last Update : Thu, 10 Sep 20

Answered by : fair-finch-gwb1sz47j6qe

$query = $db->query('YOUR QUERY HERE');

Source : https://codeigniter.com/user_guide/database/queries.html | Last Update : Tue, 11 Aug 20