no edit summary
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') ;