UPDATE `數(shù)據(jù)表名` SET `字段名` = replace(`字段名`, '要替換的字符串', '替換為') WHERE 設(shè)定條件;還有更強(qiáng)大的正則替換：update test set Content = REPLACE(Content,'abc001','test') where IDX = 2 AND Content REGEXP 'http://static.abc001.com/123.jpg';
咨詢我們
頂部