Create your Gitee Account

Explore and code with more than 6 million developers，Free private repositories ！：）

Clone or download

51.查找字符串.md 355 Bytes

authored 2019-08-12 23:23 . add:all

查找字符串'10,A,B' 中逗号','出现的次数cnt

题目描述

查找字符串'10,A,B' 中逗号','出现的次数cnt。

select length('10,A,B') - length(replace('10,A,B',',','')) cnt

利用字符串替换函数，将子串替换为空。(源串长度-替换后的串长度)/子串长度=子串出现次数