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

Method SetWhereClause( ) - of API Reference pub

 public   mixed rstoetter\cSmartSqlStatement\cSmartSqlStatement::SetWhereClause(string $str_where)

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

The method SetWhereClause( ) sets a new WHERE 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_where string - <p>the new WHERE</p>