UPDATE phome_ecms_news_data_1 set newstext = REPLACE( newstext,'src=\\\"', 'src=\\\"/d/file/' ) where LOCATE('src', newstext)>0
简单点的:
UPDATE phome_ecms_news_data_1 set newstext = REPLACE(`titlepic`, 'd/file/', '/d/file/')
UPDATE phome_ecms_news_data_1 set newstext = REPLACE( newstext,'src=\\\"', 'src=\\\"/d/file/' ) where LOCATE('src', newstext)>0
简单点的:
UPDATE phome_ecms_news_data_1 set newstext = REPLACE(`titlepic`, 'd/file/', '/d/file/')