01 2019 档案

计算mysql中某个字段某字符出现的次数，case when 和 截取字符的用法
摘要：select LENGTH(type) - LENGTH(replace(type,'_','')) as counts from sa_log_olap where type like 'XX_XXXX_%' CASE WHEN LENGTH(type) - LENGTH(replace(type 阅读全文
posted @ 2019-01-04 16:38 小魔魔 阅读(1425) 评论(0) 推荐(0)