U.S. Cities are Incorrect

2 years 2 months ago - 2 years 2 months ago #4417 by Tim Johns
I was just wondering if you guys have database tables I can insert to correct the U.S. cities? I notice that If I look at the cities in Pakistan, they have spaces correctly between two-worded towns. The U.S. cities are incorrect as they have spaces between two-worded towns removed... [for example] LosAngeles, when it should be Los Angeles. This is not the case for all cities, but most of them. At least all of the ones in California are 'smashed together'.

Additionally, if you don't have a cities table that has the correct spelling (with spaces between words), maybe you can provide me with a MySQL Query that I can run on the js_job_cities table and do something like: "when a lowercase letter is immediately followed by an uppercase letter, insert a space". I'm not familiar enough with MySQL to write the query myself.
2 years 2 months ago #4418 by Ahmad
Replied by Ahmad on topic U.S. Cities are Incorrect

If you are using pro version.
Ask free World cities database from

It is correct data with space.

Please write your valuable review JS Jobs and JS Support Ticket at JED.
The following user(s) said Thank You: Tim Johns
Time to create page: 0.241 seconds

Please publish modules in offcanvas position.