mysql 通过查询条件查出指定字段记录数。

SELECT ip_name,count(ip_name) as ipcount from IP GROUP BY ip_name where ipcount >1;

本以为可以像在MSsql一样现在，发现不行，下面是在Mysql方法

SELECT ip_name,count(ip_name) as ipcount from IP  GROUP BY ip_name  having count(ip_name)>1;