mysql 字符串截取问题,如图,只需要数字开头的前面部分,如图只需要标 ...答:if(Locate('0',REVERSE(filename)) >0,Locate('0',REVERSE(filename)),999),if(Locate('1',REVERSE(filename)) >0,Locate('1',REVERSE(filename)),999),if(Locate('2',REVERSE(filename)) >0,Locate('2',REVERSE(filename)),999),if(Locate('3',REVERSE(filename)) >0,Locate('...