title: mysql - finding users who login from the same ip
body: <p>I'm running a dating site and i want to find out which users have more than one profile.</p>
  
  <p>i have a userlog table with (userid, ip address) and i want to find all users who login from the same ip address - i only want the results where more than 1 user logs in from the same ip.</p>
  
  <p>thanks in advance.</p>