/SQL/How to set sql_mode for a query in CI model

How to set sql_mode for a query in CI model

$this->db->query('SET SESSION sql_mode = ""');

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

Source: stackoverflow.com

Similar codes

0 vote222 views1 answer
Character count sql
SQL
12 votes214 views1 answer
Docker mysql random root password
SQL
3 votes225 views1 answer
Only join in sql
SQL
0 vote220 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote214 views1 answer
Oracle running queries sql
SQL
2 votes211 views1 answer
Oracle drop table free up space
SQL
0 vote214 views1 answer
Get create sql of hibernqte entity
SQL
0 vote235 views1 answer
How to map sql column to custom names
SQL
0 vote231 views1 answer
Vbscript connect mssql
SQL
0 vote220 views2 answers
Mysql add days to date
SQL