select len(字段名)-len(replace(字段名,'特殊字符','')) from 表名--比如查询字符串 '123+456+789' 中有多少个加号'+'select len('123+456+789')-len(replace('123+456+789','+','')) from 表名
