mysql 截取前7位

select  SUBSTRING(t1.xhdwswjgdm,1,7) as fild from xx;  //截取前7位

原文地址:https://www.cnblogs.com/gaobo543013306/p/12986087.html