Mathias,
To drop multiple IP, you can use distinct :
mysql> SELECT year, month, day, group_concat(distinct ip),count(*) AS access
-> FROM access
-> WHERE year = 2005
-> AND month = 5
-> GROUP BY year, month,day
-> ORDER BY year, month, day;
+------+-------+------+---------------------------+--------+
| year | month | day | group_concat(distinct ip) | access |
+------+-------+------+---------------------------+--------+
| 2005 | 5 | 13 | 192.168.0.1,192.168.0.2 | 3 |
| 2005 | 5 | 14 | 192.168.0.2 | 1 |
| 2005 | 5 | 15 | 192.168.0.3 | 1 |
+------+-------+------+---------------------------+--------+
3 rows in set (0.00 sec)
Thank you very much for your attention.
It also answer my question, but I think the Shawn´s tip is more optimized.
Any way, I appreciate your help.
Thank you,
Ronan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
