可以批量提取內(nèi)容第一張圖為標(biāo)題圖,僅供參考,修改之前先備份。

后臺-系統(tǒng)-備份與恢復(fù)數(shù)據(jù)-執(zhí)行SQL語句UPDATE phome_ecms_newsJOIN phome_ecms_news_data_1ON phome_ecms_news.id = phome_ecms_news_data_1.idSET 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='';
記得修改數(shù)據(jù)表名UPDATE phome_ecms_news SET ispic=1 WHERE titlepic<>'';
新聞熱點
疑難解答