当前位置： 首页 > 服务器 > 正文

mysql批量替换指定字符串

keyboard 发布于 2016-02-23 18:08服务器抢沙发

将字段title中的abc替换为123

UPDATE `table1` SET `title` = replace(title, 'abc', '123') WHERE `typeid` =18;

]]>

您可能还会对这些文章感兴趣！

mysql批量替换指定字符串：等您坐沙发呢！

发表评论

gravatar

? razz sad evil ! smile oops grin eek shock ??? cool lol mad twisted roll wink idea arrow neutral cry mrgreen

快捷键：Ctrl+Enter

NOTICE: You should type some Chinese word (like “你好”) in your comment to pass the spam-check, thanks for your patience!