----- Original Message ----- From: "Mike Mapsnac" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 23, 2004 11:42 PM Subject: Select help
> Hello > > I want to select from the table sum of logins for each day. Here's one way to do it. SELECT SUBSTRING(last_login, 1, 10) AS day, login_count FROM table GROUP BY day ORDER BY day ASC; > For example: > Date Logins > 2004-01-22 10 > 2004-01-23 12 > > Any ideas if such select is possible? > > +--------------------------+--------------------------+ > | Field | Type | > +--------------------------+--------------------------+ > | login_count | int(4) | > | last_login | datetime | > Mikael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]