Cheg

I can't disable duplicates from the very beginning. There are a few situations, such as a user signing up with fake email addresses before realizing that won't work, where they would need to create a second account with a legit address. However, they very rarely come back, so culling some of the duplicates after time (will be the first in 2 years) is fine. SELECT signup_ip FROM Bob INNER JOIN (SELECT signup_ip FROM Bob GROUP BY signup_ip HAVING count(id) > 1) dup ON Bob.signup_ip = dup.signup_ip Is this correct? I tried reading the links, but it's like reading the law. Everything is explained in a way for experienced coders to understand, but is not friendly for us total newbies. The table has 588,000 rows, so it sounds like this may be an issue. Are there any alternative, less resource intensive methods? Edit: There are about 35000 unique signup_ip values.

Nothing for this?

Hello, I have a table named Bob, and 2 colums titled Column 1 and Column 2. In Column 1 is the value signup_ip and Column 2 lists an ip. What query do I use to get a list of all IP's that are listed more than once? I am trying to delete some duplicate users from my database. Alternatively, will the following work for what I need? SELECT firstname, lastname, list.address FROM list INNER JOIN (SELECT address FROM list GROUP BY address HAVING count(id) > 1) dup ON list.address = dup.address If so, how do I insert my column/field names into this?