Take away y in placenames

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';

---