帝国cms标题、内容、关键词批量替换sql语句

帝国cms标题、内容、关键词常用的批量替换sql语句
可以替换网站上出现的敏感词
例子如下：
/* phome_ecms_news表 */
update phome_ecms_news SET title=REPLACE(title,'官网','网站');
update phome_ecms_news SET title=REPLACE(title,'轰炸','轰轰');
update phome_ecms_news SET title=REPLACE(title,'破解','开心');

update phome_ecms_news SET smalltext=REPLACE(smalltext,'官网','网站');
update phome_ecms_news SET smalltext=REPLACE(smalltext,'轰炸','轰轰');
update phome_ecms_news SET smalltext=REPLACE(smalltext,'破解','开心');

update phome_ecms_news SET keyboard=REPLACE(keyboard,'官网','网站');
update phome_ecms_news SET keyboard=REPLACE(keyboard,'轰炸','轰轰');
update phome_ecms_news SET keyboard=REPLACE(keyboard,'破解','开心');

/*phome_ecms_news_data_1表 */
update phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'官网','网站');
update phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'轰炸','轰轰');
update phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'破解','开心');

update phome_ecms_news_data_1 SET infotags=REPLACE(infotags,'官网','网站');
update phome_ecms_news_data_1 SET infotags=REPLACE(infotags,'轰炸','轰轰');
update phome_ecms_news_data_1 SET infotags=REPLACE(infotags,'破解','开心');

/*phome_ecms_news_check表 */
update phome_ecms_news_check SET title=REPLACE(title,'官网','网站');
update phome_ecms_news_check SET title=REPLACE(title,'轰炸','轰轰');
update phome_ecms_news_check SET title=REPLACE(title,'破解','开心');

update phome_ecms_news_check SET smalltext=REPLACE(smalltext,'官网','网站');
update phome_ecms_news_check SET smalltext=REPLACE(smalltext,'轰炸','轰轰');
update phome_ecms_news_check SET smalltext=REPLACE(smalltext,'破解','开心');

update phome_ecms_news_check SET keyboard=REPLACE(keyboard,'官网','网站');
update phome_ecms_news_check SET keyboard=REPLACE(keyboard,'轰炸','轰轰');
update phome_ecms_news_check SET keyboard=REPLACE(keyboard,'破解','开心');
/*phome_ecms_news_check_data表 */
update phome_ecms_news_check_data SET newstext=REPLACE(newstext,'官网','网站');
update phome_ecms_news_check_data SET newstext=REPLACE(newstext,'轰炸','轰轰');
update phome_ecms_news_check_data SET newstext=REPLACE(newstext,'破解','开心');
update phome_ecms_news_check_data SET infotags=REPLACE(infotags,'官网','网站');
update phome_ecms_news_check_data SET infotags=REPLACE(infotags,'轰炸','轰轰');
update phome_ecms_news_check_data SET infotags=REPLACE(infotags,'破解','开心');
/* phome_enewstags */
update  phome_enewstags SET tagname=REPLACE(tagname,'官网','网站');
update  phome_enewstags SET tagname=REPLACE(tagname,'轰炸','轰轰');
update  phome_enewstags SET tagname=REPLACE(tagname,'破解','开心');
/* phome_dp_tagsadd表 */
update  phome_dp_tagsadd SET bname=REPLACE(bname,'官网','网站');
update  phome_dp_tagsadd SET bname=REPLACE(bname,'轰炸','轰轰');
update  phome_dp_tagsadd SET bname=REPLACE(bname,'破解','开心');