mysql 函数相关截取字符串123_56_以后的字符 :select SUBSTRING(123_56,LOCATE(_,123_56)+1) fr
mysql 函数相关
截取字符串"123_56" '_' 以后的字符 :select SUBSTRING("123_56",LOCATE('_',"123_56")+1) from DUALLOCATE 判断指定字符出现的位置.select LOCATE('_',"123_56") from DUAL 返回 4,下标从1开始.SUBSTRING 字符串截取select SUBSTRING("123_56",4) from dual 返回 _56