Mathias,
Hi, look at group by ... with rollup at : http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Thank you very much for your help.
My needs arenīt this, exactly.
GROUP BY WITH ROLLUP, returns me several lines of the same day (one per IP), plus the total.
I need that every year-month-day-ip be counted as 1. And I need this total per day.
Thank you,
Ronan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]