/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

3 votes118 views1 answer
Oracle user quota unlimited
SQL
36 votes117 views3 answers
Finding duplicate column values in table with sql
SQL
10 votes137 views2 answers
What is database
SQL
16 votes142 views3 answers
Get count of duplicate records
SQL
0 vote121 views1 answer
Php delete database
SQL
0 vote125 views1 answer
Split string by comma in sql server
SQL
10 votes132 views2 answers
Show tables in schema oracle
SQL
2 votes152 views1 answer
Find column in all stored procedures sql server
SQL
8 votes119 views2 answers
Mysql query dates between two dates
SQL
7 votes121 views3 answers
SQL create a new table
SQL