Home  >  Article  >  Database  >  字符串替换-mysql如何替换第一位字符串

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

WBOY
WBOYOriginal
2016-06-06 09:37:351780browse

mysql字符串替换

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

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