MySQL替换文字

UPDATE `yx_archives` SET `keywords` = REPLACE(`keywords`, '最', '');
UPDATE `yx_archives` SET `title` = REPLACE(`title`, '最', '');
UPDATE `yx_archives` SET `description` = REPLACE(`description`, '最', '');
UPDATE `yx_archives` SET `shorttitle` = REPLACE(`shorttitle`, '最', '');
UPDATE `yx_addonarticle` SET `body` = REPLACE(`body`, '最', '');

UPDATE `yx_arctype` SET `description` = REPLACE(`description`, '最', '');
UPDATE `yx_arctype` SET `keywords` = REPLACE(`keywords`, '最', '');
UPDATE `yx_arctype` SET `content` = REPLACE(`content`, '最', '');

 

UPDATE `hr_addonarticle` SET `body` = REPLACE(`body`, '全球级', '');

 

UPDATE `ecs_category` SET `keywords` = REPLACE(`keywords`, '首发', '');
UPDATE `ecs_category` SET `cat_desc` = REPLACE(`cat_desc`, '首发', '');
UPDATE `ecs_category` SET `cat_title` = REPLACE(`cat_title`, '首发', '');

UPDATE `ecs_goods` SET `goods_name` = REPLACE(`goods_name`, '首发', '');
UPDATE `ecs_goods` SET `goods_title` = REPLACE(`goods_title`, '首发', '');
UPDATE `ecs_goods` SET `keywords` = REPLACE(`keywords`, '首发', '');
UPDATE `ecs_goods` SET `goods_desc` = REPLACE(`goods_desc`, '首发', '');

UPDATE `ecs_article_cat` SET `keywords` = REPLACE(`keywords`, '首发', '');
UPDATE `ecs_article_cat` SET `cat_desc` = REPLACE(`cat_desc`, '首发', '');
UPDATE `ecs_article_cat` SET `page_title` = REPLACE(`page_title`, '首发', '');

UPDATE `ecs_article` SET `title` = REPLACE(`title`, '首发', '');
UPDATE `ecs_article` SET `keywords` = REPLACE(`keywords`, '首发', '');
UPDATE `ecs_article` SET `description` = REPLACE(`description`, '首发', '');
UPDATE `ecs_article` SET `content` = REPLACE(`content`, '首发', '');