执行以下脚本的时候请 先备份数据库！文本存放的新闻正文字段不可用！

新闻正文字段作为主表的情况用以下语句：

update phome_ecms_news set titlepic =concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, ‘src=’, -1),’.gif’,1),'”‘,”),’.gif’) where newstext like ‘%.gif%’ and titlepic=”;

update phome_ecms_news set titlepic =concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, ‘src=’, -1),’.jpg’,1),'”‘,”),’.gif’) where newstext like ‘%.jpg%’ and titlepic=”;

update phome_ecms_news set titlepic =concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, ‘src=’, -1),’.png’,1),'”‘,”),’.png’) where newstext like ‘%.png%’ and titlepic=”;

新闻正文字段作为副表的情况用以下语句：

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, ‘src=’, -1),’.gif’,1),'”‘,”),’.gif’) where a.newstext like ‘%.gif%’ and b.titlepic=” and a.id=b.id;

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, ‘src=’, -1),’.jpg’,1),'”‘,”),’.jpg’) where a.newstext like ‘%.jpg%’ and b.titlepic=” and a.id=b.id;

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, ‘src=’, -1),’.png’,1),'”‘,”),’.png’) where a.newstext like ‘%.png%’ and b.titlepic=” and a.id=b.id;

声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。