I'm trying to select the distinct IPs from all time from today's date, and it returned 39 rows, but it's suppose to be less, since some of the IPs aren't distinct since they visited from before today. What am I doing wrong?

```
SELECT DISTINCT (ip), DATE AS tempDate
FROM  `ipAll` 
HAVING tempDate =  '2015-12-29'
LIMIT 100

```