题解 | 原字符串长度-逗号替换为空字符串后的字符串长度
查找字符串中逗号出现的次数
https://www.nowcoder.com/practice/e3870bd5d6744109a902db43c105bd50
select id, LENGTH(string)-LENGTH(REPLACE(string,',','')) as cnt from strings;
查找字符串中逗号出现的次数
https://www.nowcoder.com/practice/e3870bd5d6744109a902db43c105bd50
select id, LENGTH(string)-LENGTH(REPLACE(string,',','')) as cnt from strings;
相关推荐