1、UPDATE phome_ecms_news
JOIN phome_ecms_news_data_1
ON phome_ecms_news.id = phome_ecms_news_data_1.id
SET phome_ecms_news.titlepic = (select reverse(substring(reverse(substring_index(substring(newstext,locate('src=',newstext)+6),'"',1)),2,255)) from phome_ecms_news_data_1 where id=phome_ecms_news.id)
WHERE phome_ecms_news.titlepic='';
2、UPDATE phome_ecms_news SET ispic=1 WHERE titlepic<>'';
仅供参考，修改之前先备份
|
顶部 
加入收藏夹
2019-08-03 16:50:39 
已设置保密
回复
引用
报告
编辑
删除