å¸å›½CMSæ‰¹é‡æå–æ–°é—»æ£æ–‡å†…å®¹çš„ç¬¬ä¸€å¼ å›¾ç‰‡ä½œä¸ºæ ‡é¢˜ç¼©ç•¥å›¾çš„SQLè¯å¥

搜索引擎优化原创技术博客，关注整合网络营销，分享各类网站SEO策略与优化成功案例，曾任多家商业网站的SEO顾问！为商业网站制定整体SEO战略，创造庞大搜索流量，为企业网站提升关键词排名，带动产品销售。为发展助力，成就你我！

郝聪 , 2020/03/12 18:11 , 建站优化 , 评论(0) , 阅读(3542) , Via 本站原创

大 | 中 | 小

æ‰§è¡Œä»¥ä¸‹è„šæœ¬çš„æ—¶å€™è¯· å…ˆå¤‡ä»½æ•°æ®åº“ï¼æ–‡æœ¬å˜æ”¾çš„æ–°é—»æ£æ–‡å—æ®µä¸å¯ç”¨ï¼

æ–°é—»æ£æ–‡å—æ®µä½œä¸ºä¸»è¡¨çš„æƒ…å†µç”¨ä»¥ä¸‹è¯å¥ï¼š

XML/HTMLä»£ç

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='';

æ–°é—»æ£æ–‡å—æ®µä½œä¸ºå‰¯è¡¨çš„æƒ…å†µç”¨ä»¥ä¸‹è¯å¥ï¼š

XML/HTMLä»£ç

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;

郝聪SEO博客：SEO顾问咨询服务公司