pub rstoetter cSmartSqlStatement cSmartSqlStatement::SetHavingClause() - rstoetter/csmartsqlstatement-php GitHub Wiki

Method SetHavingClause( ) - of API Reference pub

 public   mixed rstoetter\cSmartSqlStatement\cSmartSqlStatement::SetHavingClause(string $str_having)

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

The method SetHavingClause( ) sets a new HAVING 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->SetHavingClause( '( c = "123" OR d = 25 OR h = gf) ' ); *

Arguments

• $str_having string - <p>the new HAVING</p>