select sum(coalesce(length(course)-length(replace(course,',','')) + 1,0)) staff_nums
from    cultivate_tb

孩子们，企业里常用coalesce函数来输出非null值