Question

mysql数据库这个字段的部分内容替换下怎么替换？具体请看描述，10分谢谢

表：caiji_rule
字段：setting
原有内容："dbuser";s:7:"myogwin";s:4:"dbpw";s:7:"myogwin"
替换成："dbuser";s:7:"ogwin";s:4:"dbpw";s:7:"ogwin84"

如何替换？多谢解答 在线等！
UPDATE caiji_rule SET setting=REPLACE(setting, 's:6:"dbuser";s:7:"myogwin";s:4:"dbpw";s:7:"myogwin";s:6:"dbname";s:7:"myogwin";', 's:6:"dbuser";s:4:"root";s:4:"dbpw";s:8:"drmfslx1";s:6:"dbname";s:12:"wffzbbscaiji";');
正解在此 以后来自己看。

Answer 1

更换（设置，'我'，''，1）替换（的设置，myogwin'，'的ogwin84“）

Answer 2

update caiji_rule set setting ='"dbuser";s:7:"ogwin";s:4:"dbpw";s:7:"ogwin84"' where setting ='"dbuser";s:7:"myogwin";s:4:"dbpw";s:7:"myogwin"' ;

追问

替换内容："dbuser";s:7:"root";s:4:"dbpw";s:7:"drmfslx1";s:6:"dbname";s:7:"wffzbbscaiji";
原有内容："dbuser";s:7:"myogwin";s:4:"dbpw";s:7:"myogwin";s:6:"dbname";s:7:"myogwin";

追答

找个豆腐 撞死得了

追问

0.0

Answer 3

replace(setting,'my','',1)
replace(setting,'myogwin','ogwin84')

追问

替换内容："dbuser";s:7:"root";s:4:"dbpw";s:7:"1552555";s:6:"dbname";s:7:"wffzbbscaiji";
原有内容："dbuser";s:7:"myogwin";s:4:"dbpw";s:7:"myogwin";s:6:"dbname";s:7:"myogwin";

追答

你就慢慢扣呗