title: Yii2: update field with query builder
body: <p>How can I update field with query builder in Yii2? I can't find this in documentation.</p>
  
  <p>Thanks!</p>
  
  <p><strong>UPD</strong></p>
  
  <p>This is the solution:</p>
  
  <pre><code>// UPDATE
  $connection = Yii::$app-&gt;db;
  $connection-&gt;createCommand()-&gt;update('user', ['status' =&gt; 1], 'age &gt; 30')-&gt;execute();
  </code></pre>