Jump to content

SQL query to find users registered with the same IP?


Recommended Posts

SELECT ip_address, COUNT(ip_address) AS c FROM forums_posts
WHERE topic_id = 1224
GROUP BY ip_address
HAVING c > 1;

Someone actually made 5 accounts... and many others 2 or 3, lol. It may be poeple just in the same net, but... well I'll have to check signup times and stuff.

Edited by -FP
Link to comment
Share on other sites


  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...