Spot the difference

[master82]

I have a table that consists of 6 fields

 

tableid - unique auto incremental value

code - a code given to each user

userid - the unique id of the user

time - unix timestamp of when the code was issued

ip - the ip of the user when code was issued

status - small description of why the code was given

 

Now what I need to do is identify all the userids that appear with the same code only and list them, so that i can see if the same code is in use by multiple users.

 

I know its probably something simple, but im having an off day

 

Any help would be greatful

[tapos]

u can use 'order by code' in the query

 

--

Tapos Pal

[master82]

I have done (group by code) but that also shows every user who does have a code to themselves. Creating a long list!

 

What i need (if possible) is to see ONLY those users who have the same code as another user, with the code they were given

 

eg

 

see Mr X with code 12345

and Mr Y with code 12345

but not Ms Z with code 54321

 

hope im explaining this right?

[jitesh]

select * from `table` GROUP BY code having (count(userid) > 1)