MySQL字符串替换

发布日期：2018-02-24 16:30
分类：SQL
浏览次数：170
我有一列包含数据 urls (id, url)
http://www.example.com/articles/updates/43
http://www.example.com/articles/updates/866
http://www.example.com/articles/updates/323
http://www.example.com/articles/updates/seo-url
http://www.example.com/articles/updates/4?something=test

我想把以上URL中的“updates”改为“news”,有没有可能实现它的脚本？

回答:

UPDATE your_table
SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
WHERE your_field LIKE '%articles/updates/%'
上一篇Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)
ERROR 1130 (00000): Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server下一篇
下一篇ERROR 1130 (00000): Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server

最新文章