MYSQL直接替换字段内容写法

<pre class="brush:sql;toolbar:false">#加条件的替换方式<br/>UPDATE wp_options SET option_value = replace( option_value, &#39;被替换的字符串&#39;, &#39;替换后的字符串&#39; ) WHERE option_name = &#39;home&#39; OR option_name = &#39;siteurl&#39;;<br/>#多字段替换方式<br/>UPDATE wp_posts SET post_content = replace( post_content, &#39;被替换的字符串&#39;, &#39;替换后的字符串&#39;),guid = replace( guid, &#39;被替换的字符串&#39;, &#39;替换后的字符串&#39; ) ;<br/></pre><pre class="brush:sql;toolbar:false">#转移\字符的应用<br/>UPDATE cmf_material_model SET `more` = replace(`more`, &#39;http:\\/\\/www.80zx.com&#39;, &#39;https:\\/\\/www.80zx.com&#39;) where `more` like &#39;%http:\\\\/\\\\/www.80zx.com%&#39;<br/></pre><pre class="brush:sql;toolbar:false">UPDATE crm_customer SET newkf = trim(&#39;,&#39; from (replace( concat(&#39;,&#39;,newkf,&quot;,&quot;), &#39;,159159,&#39;, &#39;&#39; ))) WHERE 1=1;<br/></pre><pre class="brush:sql;toolbar:false">#截取加判断<br/>UPDATE `crm_customer` SET `contact`=substring_index(`contact`,&quot; &quot;,1) where CHAR_LENGTH(`contact`)&gt;22 AND substring_index(`contact`,&quot; &quot;,1)&gt;11;<br/></pre><p><br/></p>