update 表名 set 字段名=replace(字段名,'aaaa','cccc'); //移除链接中noopener属性 UPDATE wp_posts SET post_content = REPLACE(post_content,'','')