Convert first letters in placenames to capitals

Fra TNG_Wiki
Spring til navigation Spring til søgning

This sets place names in a general accepted format. So new york city, becomes New York City

Copy and paste the text between the lines into the MySQL section of your MySQL admin, IMPORTANT: Make a backup before you try anything and use this at your own risk!


UPDATE tng_people SET birthplace= concat(upper(left(birthplace, 1 )),mid(birthplace, 2 ));
UPDATE tng_people SET altbirthplace= concat(upper(left(altbirthplace, 1 )),mid(altbirthplace, 2 ));
UPDATE tng_people SET deathplace= concat(upper(left(deathplace, 1 )),mid(deathplace, 2 ));
UPDATE tng_people SET burialplace= concat(upper(left(burialplace, 1 )),mid(burialplace, 2 ));
UPDATE tng_families SET marrplace= concat(upper(left(marrplace, 1 )),mid(marrplace, 2 ));
UPDATE tng_families SET divplace= concat(upper(left(divplace, 1 )),mid(divplace, 2 ));