利用replace、length的内置函数
SELECT id, length(field) - length(replace(field,',',''))+1 as count FROM `table` where 1
本文共 169 字,大约阅读时间需要 1 分钟。
利用replace、length的内置函数
SELECT id, length(field) - length(replace(field,',',''))+1 as count FROM `table` where 1
转载于:https://www.cnblogs.com/firstForEver/p/4891815.html