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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

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