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