This question is about length.
就是用原字符串长度，减去用“空格”替代“要查出符号”的字符串的长度

SELECT
LENGTH("10,A,B")-LENGTH(REPLACE("10,A,B",","," "))
AS cnt