daveh33 Posted November 17, 2007 Share Posted November 17, 2007 I have a database with 20,000 records - the fields are ip, datetime, pageurl Is there a way to do a mysql query where it will return the all results where I specify the pageurl but doesn't include duplicates of the ip field? Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted November 17, 2007 Share Posted November 17, 2007 SELECT DISTINCT(IP) FROM tablename WHERE url = 'www.phpfreaks.com' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.