mysql - 数数

Question

我有以下数字:

0,37,38,39,40,43,54,55,56,57,60,67,68,71,76,79,81,84,91,97,105,111,116,117,37,38,39,40,43,54,55,56,57,60,67,68,71,76,79,81,84,88,91,97,105,111,116,117,118,119,37,38,39,40,43,54,55,56,57,60,67,68,71,76,79,81,84,88,91,97,105,111,116,117,120,121,124,130,139,143,151,155,157,167,172,182,187,189,190,195,200,201,227,228,230,232,233,234,235,236,238,239,240,241,242,243,244,246,247,281,282,283,284,285,286,287,289,290,316,331,341,342,343,344,351,369,370,396,399,403,404,405,406,407

我想知道有多少个数字。例如……

SELECT COUNT (11,12,13,14,15,16,17,18,19,20) 

...应该返回 10 个数字。有什么方法可以使用 MySQL 来实现吗？

Answer 1

结合使用length 和replace 函数。

mysql> SELECT length(replace('1,2,3,4,5,6,7,8,9,0', ',', '' ));
+--------------------------------------------------+
| length(replace('1,2,3,4,5,6,7,8,9,0', ',', '' )) |
+--------------------------------------------------+
|                                               10 |
+--------------------------------------------------+
1 row in set (0.33 sec)

但是，您必须处理字符串中存在的其他字符(如果有的话)。

我也希望您问的是字符串中的位数，而不是 CSV 的数量。