cSmartSqlStatement::SetGroupByClause() - rstoetter/csmartsqlstatement-php GitHub Wiki

Method SetGroupByClause( )

 public   mixed rstoetter\cSmartSqlStatement\cSmartSqlStatement::SetGroupByClause(string $str_group_by)

• Namespace : rstoetter\cSmartSqlStatement
• Class name: cSmartSqlStatement
• This method is defined by rstoetter\cSmartSqlStatement\cSmartSqlStatement

The method SetGroupByClause( ) sets a new GROUP BY clause The whole statement will be rescanned

Example: $obj_sql_statement = new cSmartSqlStatement('select'); $query = "select * from tbl where x= 5 and z = sqrt( v ) "; $obj_sql_statement->ScanStatement( $query ); $obj_sql_statement->SetGroupByClause( '( c = "123" OR d = 25 OR h = gf) ' ); *

Arguments

• $str_group_by string - <p>the new GROUP BY</p>