update table_name set aa=concat(mid(aa,1,1),"*",mid(2,9)); 转载于:https://www.cnblogs.com/LiLiliang/p/8573479.html