sql 计算子字符串在父字符串中出现次数的一个非常简单的办法

select length(sn)-length(replace(sn,',','')) from ...

update ads_netdevice_info set islogic=length(sn)-length(replace(sn,',',''))+1