假设您没有像'123,123'这个应该工作：

Assuming you don't have values like '123,123,' (note the comma at the end) this should work:

SELECT
LENGTH(yourColumn) - LENGTH(REPLACE(yourColumn, ',', '')) + 1 AS numberOfItemsInRow
FROM yourTable;

查找更多信息这里。

但是，数据库！