Take away y in placenames

From TNG_Wiki
Jump to navigation Jump to search

This query takes away the "y" entered in place names.

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 = "" WHERE marrplace='Y';
UPDATE tng_families SET divplace = "" WHERE divplace='Y';
UPDATE tng_people SET birthplace = "" WHERE birthplace='Y';
UPDATE tng_people SET altbirthplace = "" WHERE altbirthplace='Y';
UPDATE tng_people SET deathplace = "" WHERE deathplace='Y';
UPDATE tng_people SET burialplace = "" WHERE burialplace='Y';
UPDATE tng_events SET eventplace = "" WHERE eventplace='Y';
UPDATE tng_places SET place = "" WHERE place='Y';

UPDATE tng_families SET marrplace = "" WHERE marrplace='y';
UPDATE tng_families SET divplace = "" WHERE divplace='y';
UPDATE tng_people SET birthplace = "" WHERE birthplace='y';
UPDATE tng_people SET altbirthplace = "" WHERE altbirthplace='y';
UPDATE tng_people SET deathplace = "" WHERE deathplace='y';
UPDATE tng_people SET burialplace = "" WHERE burialplace='y';
UPDATE tng_events SET eventplace = "" WHERE eventplace='y';
UPDATE tng_places SET place = "" WHERE place='y';