MYSQL直接替换字段内容写法

#加条件的替换方式
UPDATE wp_options SET option_value = replace( option_value, '被替换的字符串', '替换后的字符串' ) WHERE option_name = 'home' OR option_name = 'siteurl';
#多字段替换方式
UPDATE wp_posts SET post_content = replace( post_content, '被替换的字符串', '替换后的字符串'),guid = replace( guid, '被替换的字符串', '替换后的字符串' ) ;

#转移\字符的应用
UPDATE cmf_material_model SET `more` = replace(`more`, 'http:\\/\\/www.80zx.com', 'https:\\/\\/www.80zx.com') where `more` like '%http:\\\\/\\\\/www.80zx.com%'

UPDATE crm_customer SET newkf = trim(',' from (replace( concat(',',newkf,","), ',159159,', '' ))) WHERE 1=1;

#截取加判断
UPDATE `crm_customer` SET `contact`=substring_index(`contact`," ",1) where CHAR_LENGTH(`contact`)>22 AND substring_index(`contact`," ",1)>11;