/是获得每条的/
select length(字段名) - length(replace(字段名, '要查询的某个词','')) from 表 //字段名即列名
/获取全部的总数/
select sum(numb) counts from ( select length(字段名) - length(replace(字段名, '要查询的某个词','')) numb from 表)
/是获得每条的/
select length(字段名) - length(replace(字段名, '要查询的某个词','')) from 表 //字段名即列名
/获取全部的总数/
select sum(numb) counts from ( select length(字段名) - length(replace(字段名, '要查询的某个词','')) numb from 表)