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

Question

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?

Answer 1

try this

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