select sum(case when course is null then 0 else length(course) - length(replace(course,',','')) +1 end) as staff_nums from cultivate_tb
统计课程数, 计算非空情况的“,”个数,用字符串长度减去去掉“,”之后的字符串长度
select sum(case when course is null then 0 else length(course) - length(replace(course,',','')) +1 end) as staff_nums from cultivate_tb
统计课程数, 计算非空情况的“,”个数,用字符串长度减去去掉“,”之后的字符串长度