MySQL批量替换单字段数据
- WBOYOriginal
- 2016-06-07 17:51:14982browse
一个简单的update与replace结合就可以实现在mysql数据库中实现数据库字段中的部份字符进行替换了，有需要的朋友参考下。
| 代码如下 | 复制代码 |
| update content_type_center set field_center_url_value = replace(字段名,'要替换','替换成的内容'); | |
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql中索引使用一些优化方法与注意事项Next article：常用mysql几条sql语句