Cookies help us deliver our services. By using our services, you agree to our use of cookies.

Changes

Jump to: navigation, search

Change twp

28 bytes added, 20:08, 18 June 2011
Text replace - "<syntaxhighlight lang="SQL">" to "<syntaxhighlight lang="SQL" enclose="div">"
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!
--------<syntaxhighlight lang="SQL" enclose="div">
UPDATE tng_families SET marrplace = REPLACE(marrplace,'Twp.','Township');
UPDATE tng_families SET divplace = REPLACE(divplace,'Twp.','Township');
--------
in case you use NO dot in Twp
--------<syntaxhighlight lang="SQL" enclose="div">
UPDATE tng_families SET marrplace = REPLACE(marrplace,'Twp','Township');
UPDATE tng_families SET divplace = REPLACE(divplace,'Twp','Township');
13,914
edits

Navigation menu