Not quite what I need.. Though, it's very close :) The problem is that with the query given, it only shows one username for each IP.. I actually want to show ALL usernames for each IP with the IP occurs more than once... (and ignore the users who have a distinct IP address).
David ----- Original Message ----- From: "David Hugh-Jones" <[EMAIL PROTECTED]> To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 6:19 PM Subject: Re: Query help... > > Try > SELECT lastip,username FROM users GROUP BY lastip HAVING count(*) > 1; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
