Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`, `login_ip`
HAVING COUNT(`id`) 2
ORDER BY COUNT(`id`) DESC
LIMIT 0, 15;
On Mar 19, 2012, at 12:06 PM, Steven
-Original Message-
From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
Sent: March 19, 2012 12:44 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Group_Concat help...
Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test
; 2012/03/19 12:06 -0400, Steven Staples
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`
HAVING COUNT(`id`) 2
ORDER BY COUNT(`id`)
