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.
2011/3/2 Tompkins Neil <neil.tompkins@stripped>
> I've the following basic table
> 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 ?