Latest posts for the topic "Looking up city?"

Looking up city?

ajmas — GMT

I am wanting to be able to lookup a city in the database and then display the associated information on the place. I tried the following: Code:

select name,fcode,admin1 from geoname where name like '%Quebec%' and country = 'ca' and fcode = 'p.ppl'

but this did not return any results. Am I doing something wrong?

Re:Looking up city?

ajmas — GMT

Never mind, found the answer. Looks like I didn't consider accents. This works: Code:

select ge.* from geoname as ge, alternatename as al where al.alternateName like '%Quebec%' and ge.country = 'ca' and ge.geonameid = al.geonameid and ge.fcode = 'PPLA' group by ge.geonameid