Need help with MySQL query

[Fresh_ales]

First hi to all

I want to make a query in MySQL and have some problems with it...

I have made it like this

$query = "SELECT * FROM $db_stats
      WHERE user_ip NOT IN
      (
      SELECT user_ip FROM $db_stats
      GROUP BY user_ip
  )
     ";

so.... what it want?

i have user_ip-s in my db and i want to select all records that are more then 1 in database...

that means i there are 2 same ips i want to select one of them....

on the end when i see the query works well i want to delete this records...

help?

[mem0ri]

Why don't you do the initial sorting at the INSERT end instead of running a cleanup after the fact?

 

Just make the USER_IP a 'key' and run an INSERT......ON DUPLICATE KEY UPDATE...

 

 

Of course...if you already have the database, then that's not an option for the current clean-up need.  I'm actually not sure how to search the table to only get duplicated rows.

[Fresh_ales]

i know that....

but this is the case... i have database and need to cleen it up...

[Barand]

SELECT user_ip, COUNT(*) as tot

FROM $db_stats

GROUP BY user_ip

HAVING tot > 1