Same Data In Same Column

doobster

Hi,

I have a table called USER. This table contains fields like id, uname, passwd, etcc...

How can I get a listing of all id's with the same password?

LordShryku

Well, if you're going to specify a password

SELECT id
FROM table
WHERE passwd = 'blah'

doobster

No, I won't be specifying any password.

This list can have x amount of rows in it. I want to select any row's where the password columns are the same.

It doesn't matter what the password is. I just want to know if any row in the USER table has the same password as another row in the USER table.

LordShryku

Well, I don't think my brain is working on full power right now because I know there's a way to do this with a HAVING clause, but anyway, right now I'd suggest doing two queries. First, grab the passwords:

SELECT passwd
FROM user
GROUP BY passwd
HAVING count(passwd)>1

Then with the results, grab the user id's

Once you've cleaned it up, I'd suggest putting a unique attribute on the field if you want to keep it that way....

doobster

Thanks for the help. I have got it too work with the two separate queries.

But, if any one knows a faster way to do this as it is a little slow.