CODE EXAMPLE FOR SQL

codeigniter MySQL - Issue with SELECT & GROUP BY

$this->db->query("SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));");