表中字段htmlURL(html/2011/12/0800000002115400.html ),将‘html’替换成‘t’,如:“t/2011/12/0800000002115400.html”
UPDATE t_social_news_copy SET htmlURL = REPLACE(htmlURL, 'html', 't');
表中字段htmlURL(html/2011/12/0800000002115400.html ),将‘html’替换成‘t’,如:“t/2011/12/0800000002115400.html”
UPDATE t_social_news_copy SET htmlURL = REPLACE(htmlURL, 'html', 't');