MySQL 替换某字段内部分内容的UPDATE语句

复制代码 代码如下:

UPDATE dede_archives SET title= REPLACE( title, 155, 170 );
UPDATE dede_archives SET title= REPLACE( title, 180, 230 );
UPDATE dede_archives SET title= REPLACE( title, 270, 350 );
UPDATE dede_archives SET title= REPLACE( title, 210, 170 );
UPDATE dede_archives SET title= REPLACE( title, 155, 170 );