mark下length函数统计字符串长度,还有借助replace函数算字符串缩短的长度。
SELECT LENGTH('10,A,B')-LENGTH(REPLACE('10,A,B',",",""))
相关推荐