某一avatar字段,如:avatar="/images/coach/receipt_pic/2020-04-24/d044ecf2123fd97377f88f521b7ff65a.jpg";
查询所有的需要修改的数据:
SELECT * FROM ppts_personnel WHERE avatar LIKE '%/images%';
修改,去掉该字段的第一个字符斜杠:
update ppts_personnel set avatar=substring(avatar,2,Length(avatar)-1) WHERE avatar LIKE '%/images%';