Group By in List

badcom
OFFLINE
Posts: 1
Thanks: 0
Karma: 0

11 years 1 month ago #233419 by badcom

Group By in List was created by badcom

Hi,

I'd like to have a filter which would be something like:

SELECT `cb_realip` , COUNT( * ) AS total FROM `jos_comprofiler` GROUP BY `cb_realip` HAVING total > 1

Would it be possible?

I want to filter the users who have same IP address.

Thanks,
Vilmondes

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon