MySql在表中找到重复的IP地址

I have saved ipAddress in table and I want to find which ip's are duplicate.

SELECT * FROM webInformation GROUP BY ipAddress

How to fix this MySql command?

try this

SELECT `ip`, COUNT(*) cnt FROM `webInformation` GROUP BY `ip` HAVING cnt > 1;

You can do it by use of primary key and self Join.

Ex: your PK is id and table name ipTable

Query:

Select * from ipTable i1 JOIN ipTable i2
where i1.ipAddress IN(SELECT ipAddress from i2 where i2.id != i1.id);

Consider Logic Behind this query and apply same for yours. Best Of Luck