If you want one row for each combination, you'll need either a temporary table
or a sub-query. Try this:
SELECT ip_address, login_id
COUNT(*) > 1) AS x
ON basic_table.ip_address = x.ip_address;
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>From: Tompkins Neil [mailto:neil.tompkins@stripped]
>Sent: Wednesday, March 02, 2011 10:12 AM
>To: Jerry Schwartz
>Subject: Re: Query help
>Thanks for the response. This is what I was after. Although, I am looking
>to find out the email addresses used to login from the same IP ?
>On Wed, Mar 2, 2011 at 2:49 PM, Jerry Schwartz <jerry@stripped> wrote:
>> >-----Original Message-----
>> >From: Tompkins Neil [mailto:neil.tompkins@stripped]
>> >Sent: Wednesday, March 02, 2011 6:00 AM
>> >To: [MySQL]
>> >Subject: Query help
>> >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 ?
>> [JS] I haven't looked at my code lately, but I'm pretty sure that
>> GROUP BY
>> COUNT(*) > 1;
>> is what you want. You don't need to group on login_id. And, as Claudio
>> ip_address, GROUP_CONCAT(login_id, ', ') AS list_of_login_ids
>> will give you the IP addresses as well.
>> Jerry Schwartz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>> 860.674.8796 / FAX: 860.674.8341
>> E-mail: jerry@stripped
>> Web site: www.the-infoshop.com