Distinct alternative

[manicleek]

I am trying to query a DB by town name

I want it to redirect to a certain page if there is more than one town with that name

e.g.

Birmingham, England
Birmingham, USA

but I'm unsure what SQL to use.

I can't use SELECT DISTINCT as they are both the same town name it will just return 1

 

[dreameR25]

You can use the GROUP BY clause in your query. Something like this :

SELECT townName
FROM yourTable
GROUP BY townName HAVING COUNT(*) > 1

 

[vwani]

You can use something like this

CountValue = "Select Count(townName) as TownCount from yourTable Group By townName"

Later on in your program you can say if CountValue > 1 then go to page X else go to page Y