题解 | #查找字符串 10,A,B 中逗号,出现的次数cnt#
This question is about length.
就是用原字符串长度,减去用“空格”替代“要查出符号”的字符串的长度
SELECT LENGTH("10,A,B")-LENGTH(REPLACE("10,A,B",","," ")) AS cnt
This question is about length.
就是用原字符串长度,减去用“空格”替代“要查出符号”的字符串的长度
SELECT LENGTH("10,A,B")-LENGTH(REPLACE("10,A,B",","," ")) AS cnt
相关推荐