select substring('1ssssss',1,2); select INSTR('ss,ss,s,ss', ','); select LEFT('ss,sss,ss',2); 转载于:https://www.cnblogs.com/pinnasky/archive/2011/04/19/2021040.html