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?
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;