SELECT ip
FROM
(
SELECT ip, date
FROM table
GROUP BY ip, date
) AS t1
GROUP BY ip
HAVING COUNT(ip) = (SELECT COUNT(date) FROM table GROUP BY date)SELECT ip
FROM
(
SELECT ip, date
FROM table
GROUP BY ip, date
) AS t1
GROUP BY ip
HAVING COUNT(ip) > 1
