mysql 查询某个字段重复次数

skying
2020-01-16 11:46:14
数据库
mysql

例如我的表结构是这样的：
CREATE TABLE ts_b_common_express (
id smallint(1) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID',
e_name varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司名称',
e_state enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '状态',
e_code varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '编号',
f_code varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '快递鸟编号',
e_letter varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '首字母',
e_order enum('1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2' COMMENT '1常用2不常用',
e_url varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司网址',
e_zt_state tinyint(4) DEFAULT '0' COMMENT '是否支持服务站配送0否1是',
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=579 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='快递公司'
执行语法
select e_name,count(*) as count from ts_b_common_express group by e_name having count>1;