Find number of duplicate field (address) in the table.

SELECT address,
COUNT(address)
FROM domain_ip
GROUP BY address
HAVING ( COUNT(address) > 1 )