title: How to use replace query in yii2 updateAll()?
body: <p>I am using Postgresql.   My Yii2 code for the update is</p>
  <pre><code> ModelName::updateAll(['my_column' =&gt; &quot;REPLACE(my_column1,'removed_','')&quot;]);
  </code></pre>
  <p>Actual query is</p>
  <p><code>update my_table set my_column = REPLACE(my_column1,'removed_','');</code></p>
  <p>When I run my yii2 code it shows the error</p>
  <blockquote>
  <p>SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(50)
  The SQL being executed was: UPDATE &quot;my_table&quot; SET &quot;my_column1&quot;='REPLACE(my_column1,''removed_'','''')'</p>
  </blockquote>