From: Claudio Nanni
Date: March 2 2011 11:20am
Subject: Re: Query help
List-Archive: http://lists.mysql.com/mysql/224549
Message-Id: <AANLkTina_WmziVw2Gsjg5VosdNcfxmNCjTLkiiFwzNrf@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=bcaec5014c51fb1cae049d7e186a

--bcaec5014c51fb1cae049d7e186a
Content-Type: text/plain; charset=ISO-8859-1

Hi Neil,

select
   login_id,
   ip_address
from
   basic_table
group by
   login_id,ip_address
having
   count(login_id,ip_address)>1

this should work

in case you want to see also the list of emails add:

   group_concat(email_address,',') as list_of_used_emails

to the select fields.


Claudio




2011/3/2 Tompkins Neil <neil.tompkins@stripped>

> Hi
>
> I've the following basic table
>
> login_id
> email_address
> ip_address
>
> I want to extract all records from this table in which a user has used the
> same IP address but different email address to login ?
>
> Thanks,
> Neil
>



-- 
Claudio

--bcaec5014c51fb1cae049d7e186a--