select len(replace(字段名A,';','--'))-len(字段名A) from table表名 转载于:https://www.cnblogs.com/niuniu0108/p/7306330.html