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 Quote 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? Quote 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; Quote Link to comment https://forums.phpfreaks.com/topic/183128-finding-duplicates/#findComment-968288 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.