帝国CMS操作数据库替换文本

//删除正文内容为空白的采集信息，替换采集信息的标题，简介，正文

delete from phome_ecms_infotmp_news where newstext='';UPDATE phome_ecms_infotmp_news SET title=REPLACE(title,'A','');UPDATE phome_ecms_infotmp_news SET smalltext=REPLACE(smalltext,'A','');UPDATE phome_ecms_infotmp_news SET newstext=REPLACE(newstext,'A','');//替换缩略图地址，文章标题，关键词，作者，正文
//附加条件where id BETWEEN 开始ID值 and 结束ID值;
UPDATE phome_ecms_news SET titlepic=REPLACE(titlepic,'www.a.com','www.b.com') where id BETWEEN 1 and 11;UPDATE phome_ecms_news SET title=REPLACE(title,'A','B');UPDATE phome_ecms_news SET keyboard=REPLACE(keyboard,'A','B');UPDATE phome_ecms_news SET smalltext=REPLACE(smalltext,'A','B');UPDATE phome_ecms_news_data_1 SET writer=REPLACE(writer,'A','B');UPDATE phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'A','B');