Changes

Some people like to write twp where there is a township mentioned. This query changes that to Township. This query is intended if you already have everything set to Township but you import a gedcom where there are still twp's. In case you want to change the whole database you will have to replace the DELETE statement with UPDATE tng_places REPLACE (place, 'Twp.','Township'); in the first set of queries and to UPDATE tng_places REPLACE (place, 'Twp.','Township');

Some people like to write twp where there is a township mentioned. This query changes that to Township. This query is intended if you already have everything set to Township but you import a gedcom where there are still twp's. If you want to change the whole database you will have to replace the DELETE statement with UPDATE tng_places REPLACE(place, 'Twp.','Township') in the first set of queries and with UPDATE tng_places REPLACE(place, 'Twp','Township') in the second set.