sql 查询某一字段包含特定字符的数量

select case when bus_scope like '%婚纱摄影%' then 1            when bus_scope like '%婚庆策划%' then 2            when bus_scope like '%婚庆设备%' then 3            when bus_scope like '%广告策划%' then 4            when bus_scope like '%活动策略%' then 5            when bus_scope like '%地产运营%' then 6            else 7 end as ent_type,            count(distinct reg_no)            from             clue            group by case when bus_scope like '%婚纱摄影%' then 1            when bus_scope like '%婚庆策划%' then 2            when bus_scope like '%婚庆设备%' then 3            when bus_scope like '%广告策划%' then 4            when bus_scope like '%活动策略%' then 5            when bus_scope like '%地产运营%' then 6            else 7 end

今天要在mysql数据库里面查找经营范围包含‘’婚纱摄影、婚庆、广告策划、活动策划‘’的单个数量以及总共数量，开始用python搜寻比较慢，后来改用sql语句得以解决