A few Yii 2 updateAll examples:
Updating a single column:
$rows = Comment::updateAll(['status' => 1], 'type_id = 1 AND status = 0');
Updating multiple columns:
$rows = Comment::updateAll(['status' => 1, 'updated' => '2011-08-25 09:33:23'], 'type_id = 1 AND status = 0' );
Some simple Yii 1.1 examples of how to use updateAll():
In this example we want to set status = 1 WHERE type_id = 1 AND status = 0
Note this is a simple example where we are only updating one column and using a string for our condition. There are more complex options available.
$rows = Comment::model()->updateAll(array( 'status' => 1 ), 'type_id = 1 AND status = 0' );
So as you can see first comes an array of column => new_value pairs, then a condition string which is pretty much used as the WHERE clause.
An example of updating more than one column:
$rows = Comment::model()->updateAll(array( 'status' => 1, 'updated' => '2011-08-25 09:33:23' ), 'type_id = 1 AND status = 0 ' );