GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
SQL search for alternate name: How does it work?  XML
Forum Index -> FAQ - frequently asked questions
Author Message

Joined: 01/04/2014 07:20:29
Messages: 1


I'm quite new to SQL. So the answer to my question might be easy.

My SQLite database got the two geonames standard tables:

1. allcountries
2. alternatenames

The tables column names are also the standard geonames column names.

Searching for a place name in allcountries table is easy.
But how to search this database for an exsisting place name 'including' its alternate names?

How does that work? Can somebody please help and provide a SQL command example to get started?
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team