DrMcSheen

Asked:2020-05-09 13:56:58 +0800 CST2020-05-09 13:56:58 +0800 CST 2020-05-09 13:56:58 +0800 CST

东西不存在

需要将电话号码中的第一个数字8替换为数据库中的7

899999999 -> 799999999

像这样尝试：

UPDATE team_users 
SET team_user_phone=STUFF(team_user_phone,1,1,'7')
WHERE team_user_phone LIKE '8%';

给出错误信息

#1305 - FUNCTION f0106330_virtual.STUFF does not exist

如何取胜？

Best Answer

V0d01ey

您可以像这样更改您的查询：

UPDATE team_users 
  SET team_user_phone = '7'+ SUBSTR(team_user_phone, 2)
  WHERE team_user_phone LIKE '8%';

相关问题