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? Link to comment https://forums.phpfreaks.com/topic/77752-solved-sql-query-to-remove-duplicate-rows/ 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' Link to comment https://forums.phpfreaks.com/topic/77752-solved-sql-query-to-remove-duplicate-rows/#findComment-393594 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.