mxs Posted November 27, 2009 Share Posted November 27, 2009 I have mysql database with info about hotels and other accommodation. When searching for a town/city that exists in more than one country, I wish to return list of available cities eg> Boston, England Boston, USA field are just address fields ie. town and country Just can get it to work Anyone help ? Michael B&B Network Link to comment https://forums.phpfreaks.com/topic/183128-finding-duplicates/ Share on other sites More sharing options...
fenway Posted November 28, 2009 Share Posted November 28, 2009 Won't a simple where clause work? What's not working? Link to comment https://forums.phpfreaks.com/topic/183128-finding-duplicates/#findComment-967050 Share on other sites More sharing options...
zeodragonzord Posted November 30, 2009 Share Posted November 30, 2009 So let's assume that you have a hotel that exists in Boston, England and one in Boston, USA. You'll have two rows in the database table. This gives you any city that appears more than once. SELECT * FROM myTable GROUP BY city HAVING count(city) > 1; This gives you the number of times each city appears more than once. SELECT count(city), city FROM myTable GROUP BY city HAVING count(city) > 1; Link to comment https://forums.phpfreaks.com/topic/183128-finding-duplicates/#findComment-968288 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.