update replace方法

update tb_ic_url_xj SET detail_url = REPLACE(detail_url,'http://xj.gsxt.gov.cn/gjjXJ','http://xj.gsxt.gov.cn/gjjbj') WHERE last_update_time < '2017-10-01' and is_company = 1 and detail_url LIKE '%gjjXJ%';

posted @ 2017-10-31 13:13  道高一尺  阅读(2223)  评论(0)    收藏  举报