MySQL字符串替换
+ 查看更多

发布日期：2018-02-24 16:30

分类：SQL

浏览次数：97

我有一列包含数据 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/%'

http://www.electrictoolbox.com/mysql-find-replace-text/

上一篇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

MySQL字符串替换+ 查看更多

回答:

最新文章

MySQL字符串替换
+ 查看更多