UGIT: Comandos MYSQL

• Buscar repetidos en una tabla

SELECT IP, COUNT(*) Total
FROM tab_blacklist_ips
GROUP BY IP
HAVING COUNT(*) > 1