题目描述
查找字符串'10,A,B' 中逗号','出现的次数cnt。
SELECT
(
length('10,A,B') - length(REPLACE('10,A,B', ",", ""))
) / length(',') AS cnt;
查找字符串'10,A,B' 中逗号','出现的次数cnt。
SELECT
(
length('10,A,B') - length(REPLACE('10,A,B', ",", ""))
) / length(',') AS cnt;