可以批量提取内容第一张图为标题图，仅供参考，修改之前先备份。

 

使用方法

后台-系统-备份与恢复数据-执行SQL语句

UPDATEphome_ecms_newsJOINphome_ecms_news_data_1ONphome_ecms_news.id=phome_ecms_news_data_1.idSETphome_ecms_news.titlepic=(selectreverse(substring(reverse(substring_index(substring(newstext,locate('src=',newstext)+6),'"',1)),2,255))fromphome_ecms_news_data_1whereid=phome_ecms_news.id)WHEREphome_ecms_news.titlepic='';

记得修改数据表名

UPDATEphome_ecms_newsSETispic=1WHEREtitlepic<>'';