Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 字符串替换-mysql如何替换第一位字符串

字符串替换-mysql如何替换第一位字符串

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-06 09:37:35
Original
1837 people have browsed it

mysql字符串替换

在网上找了好多资料，都是解决替换字符串中出现的指定字符的方法。而没发现如何替换第n位字符串的方法。就比如下面那张图片，如何把arrchildid字段开头的3替换成2，而其它位置的3则不改变。希望大神们赐教赐教图片说明

Related labels：
mysql 字符串替换
source：php.cn
Previous article：关于mybatis批量添加(insert ……value……)mysql的一点事情 Next article：数据库-mysql进行匹配的时候可否调整匹配的顺序？
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
I would like to ask if PHP can develop green Internet software or scripts?
From 1970-01-01 08:00:00
0
0
0
Does idea git have the > icon that prompts when the file status changes like eclipse, or a similar icon?
From 1970-01-01 08:00:00
0
0
0
Why can't jQuery or DOM methods like getElementById locate elements?
From 1970-01-01 08:00:00
0
0
0
javascript - js and c++ encryption and decryption through des
From 1970-01-01 08:00:00
0
0
0
Questions about gettype and var_dump?
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