Change twp

From TNG_Wiki
Revision as of 14:06, 8 August 2010 by Henny (talk | contribs) (New page: Some people like to write twp where there is a township mentioned. This query changes that to Township. Copy and paste the text between the lines into the MySQL section of your MySQL a...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Some people like to write twp where there is a township mentioned. This query changes that to Township.


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_families SET marrplace = REPLACE(marrplace,'Twp.','Township'); UPDATE tng_families SET divplace = REPLACE(divplace,'Twp.','Township'); UPDATE tng_people SET birthplace = REPLACE(birthplace,'Twp.','Township'); UPDATE tng_people SET altbirthplace = REPLACE(altbirthplace,'Twp.','Township'); UPDATE tng_people SET deathplace = REPLACE(deathplace,'Twp.','Township'); UPDATE tng_people SET burialplace = REPLACE(burialplace,'Twp.','Township'); UPDATE tng_events SET eventplace = REPLACE(eventplace,'Twp.','Township'); DELETE FROM `tng_places` WHERE `place` like "%Twp.%"; UPDATE tng_families SET marrplace = REPLACE(marrplace,'Twp','Township'); UPDATE tng_families SET divplace = REPLACE(divplace,'Twp','Township'); UPDATE tng_people SET birthplace = REPLACE(birthplace,'Twp','Township'); UPDATE tng_people SET altbirthplace = REPLACE(altbirthplace,'Twp','Township'); UPDATE tng_people SET deathplace = REPLACE(deathplace,'Twp','Township'); UPDATE tng_people SET burialplace = REPLACE(burialplace,'Twp','Township'); UPDATE tng_events SET eventplace = REPLACE(eventplace,'Twp','Township'); DELETE FROM `tng_places` WHERE `place` like "%Twp.%";