Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 用SQL语句实现替换字符串

用SQL语句实现替换字符串

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 17:57:33
Original
1135 people have browsed it

这样可以方便我们直接在数据库中替换字符

UPDATE Friend set Name = REPLACE(Name,'脚本,'脚本之家www.jb51.net')超级简单
Related labels：
sql statement replace string
Previous article：MSSQL 清空数据库的方法 Next article：mssql自动备份及自动清除日志文件服务器设置
Statement of this Website
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
Latest Articles by Author
Latest Issues
php - How to optimize this sql?
From 1970-01-01 08:00:00
0
0
0
Error location, SQL statement
From 1970-01-01 08:00:00
0
0
0
mysql - Problems with coherent operation in ThinkPHP3.2.3?
From 1970-01-01 08:00:00
0
0
0
Laravel doesn't read POST request with FormData
From 1970-01-01 08:00:00
0
0
0
Team collaboration - What should I do if someone needs the feature I wrote as a dependency in git flow?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template