利用replace、length的内置函数
SELECT id, length(field) - length(replace(field,',',''))+1 as count FROM `table` where 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