update t_product set product_imgurl = substring(product_imgurl,20); 转载于:https://www.cnblogs.com/chuijingjing/p/9959679.html