Correction Dates 2

From TNG_Wiki
Jump to navigation Jump to search

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 marrdate = REPLACE(marrdate,'-01-',' Jan ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-02-',' Feb ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-03-',' Mar ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-04-',' Apr ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-05-',' May ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-06-',' Jun ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-07-',' Jul ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-08-',' Aug ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-09-',' Sep ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-10-',' Oct ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-11-',' Nov ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'-12-',' Dec ');

UPDATE tng_families SET divdate = REPLACE(divdate,'-01-',' Jan ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-02-',' Feb ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-03-',' Mar ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-04-',' Apr ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-05-',' May ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-06-',' Jun ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-07-',' Jul ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-08-',' Aug ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-09-',' Sep ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-10-',' Oct ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-11-',' Nov ');
UPDATE tng_families SET divdate = REPLACE(divdate,'-12-',' Dec ');

UPDATE tng_people SET birthdate = REPLACE(birthdate,'Jan.','Jan');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Feb.','Feb');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Maart','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Apr.','Apr');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Mei','May');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Juni','Jun');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Juli','Jul');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Aug.','Aug');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Sep.','Sep');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Oct.','Oct');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Nov.','Nov');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Dec.','Dec');

UPDATE tng_events SET eventdate = REPLACE(eventdate,'Jan.','Jan');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Feb.','Feb');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Maart','Mar');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Apr.','Apr');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Mei','May');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Juni','Jun');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Juli','Jul');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Aug.','Aug');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Sep.','Sep');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Oct.','Oct');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Nov.','Nov');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Dec.','Dec');

UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Jan.','Jan');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Feb.','Feb');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Maart','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Apr.','Apr');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Mei','May');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Juni','Jun');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Juli','Jul');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Aug.','Aug');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Sep.','Sep');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Oct.','Oct');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Nov.','Nov');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Dec.','Dec');

UPDATE tng_people SET burialdate = REPLACE(burialdate,'Jan.','Jan');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Feb.','Feb');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Maart','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Apr.','Apr');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Mei','May');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Juni','Jun');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Juli','Jul');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Aug.','Aug');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Sep.','Sep');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Oct.','Oct');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Nov.','Nov');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Dec.','Dec');

UPDATE tng_people SET birthdate = REPLACE(birthdate,'Maart','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Mei','May');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Juni','Jun');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Juli','Jul');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Okt','Oct');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Sept','Sep');

UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Maart','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Mei','May');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Juni','Jun');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Juli','Jul');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Okt','Oct');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Sept','Sep');

UPDATE tng_people SET deathdate = REPLACE(deathdate,'Maart','Mar');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Mei','May');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Juni','Jun');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Juli','Jul');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Okt','Oct');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Sept','Sep');

UPDATE tng_people SET burialdate = REPLACE(burialdate,'Maart','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Mei','May');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Juni','Jun');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Juli','Jul');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Okt','Oct');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Sept','Sep');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'.1.',' Jan' );
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.2.',' Feb ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.3.',' Mar ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.4.',' Apr ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.5.',' May ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.6.',' Jun ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.7.',' Jul ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.8.',' Aug ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.9.',' Sep ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.10.',' Oct ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.11.',' Nov ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.12.',' Dec ');

UPDATE tng_families SET divdate = REPLACE(divdate,'.1.',' Jan' );
UPDATE tng_families SET divdate = REPLACE(divdate,'.2.',' Feb ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.3.',' Mar ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.4.',' Apr ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.5.',' May ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.6.',' Jun ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.7.',' Jul ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.8.',' Aug ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.9.',' Sep ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.10.',' Oct ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.11.',' Nov ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.12.',' Dec ');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'.01.',' Jan ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.02.',' Feb ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.03.',' Mar ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.04.',' Apr ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.05.',' May ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.06.',' Jun ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.07.',' Jul ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.08.',' Aug ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.09.',' Sep ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.10.',' Oct ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.11.',' Nov ');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'.12.',' Dec ');

UPDATE tng_families SET divdate = REPLACE(divdate,'.01.',' Jan ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.02.',' Feb ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.03.',' Mar ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.04.',' Apr ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.05.',' May ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.06.',' Jun ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.07.',' Jul ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.08.',' Aug ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.09.',' Sep ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.10.',' Oct ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.11.',' Nov ');
UPDATE tng_families SET divdate = REPLACE(divdate,'.12.',' Dec ');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'±','Abt');
UPDATE tng_families SET divdate = REPLACE(divdate,'±','Abt');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'July','Jul');
UPDATE tng_families SET divdate = REPLACE(divdate,'July','Jul');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'Ca.','Abt');
UPDATE tng_families SET divdate = REPLACE(divdate,'Ca.','Abt');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'Ca,','Abt');
UPDATE tng_families SET divdate = REPLACE(divdate,'Ca,','Abt');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'Okt.','Oct');
UPDATE tng_families SET divdate = REPLACE(divdate,'Okt.','Oct');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'Okt','Oct');
UPDATE tng_families SET divdate = REPLACE(divdate,'Okt','Oct');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'Maart','Mar');
UPDATE tng_families SET divdate = REPLACE(divdate,'Maart','Mar');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'April','Apr');
UPDATE tng_families SET divdate = REPLACE(divdate,'April','Apr');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'April','Apr');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'April','Apr');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'April','Apr');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'April','Apr');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'April','Apr');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'yyy','');
UPDATE tng_families SET divdate = REPLACE(divdate,'yyy','');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'yyy','');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'yyy','');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'yyy','');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'yyy','');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'yy','');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'yy','');
UPDATE tng_families SET divdate = REPLACE(divdate,'yy','');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'yy','');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'yy','');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'yy','');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'yy','');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'Maa','Mar');
UPDATE tng_families SET divdate = REPLACE(divdate,'Maa','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Maa','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Maa','Mar');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Maa','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Maa','Mar');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Maa','Mar');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'febr','Feb');
UPDATE tng_families SET divdate = REPLACE(divdate,'febr','Feb');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'febr','Feb');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'febr','Feb');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'febr','Feb');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'febr','Feb');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'febr','Feb');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'Rond','Abt');
UPDATE tng_families SET divdate = REPLACE(divdate,'Rond','Abt');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Rond','Abt');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Rond','Abt');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Rond','Abt');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Rond','Abt');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Rond','Abt');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'rond','Abt');
UPDATE tng_families SET divdate = REPLACE(divdate,'rond','Abt');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'rond','Abt');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'rond','Abt');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'rond','Abt');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'rond','Abt');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'rond','Abt');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'<','Bef ');
UPDATE tng_families SET divdate = REPLACE(divdate,'<','Bef ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'<','Bef ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'<','Bef ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'<','Bef ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'<','Bef ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'<','Bef');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'>','Aft ');
UPDATE tng_families SET divdate = REPLACE(divdate,'>','Aft ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'>','Aft ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'>','Aft ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'>','Aft ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'>','Aft ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'>','Aft');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'Voor','Bef ');
UPDATE tng_families SET divdate = REPLACE(divdate,'Voor','Bef ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Voor','Bef ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Voor','Bef ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Voor','Bef ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Voor','Bef ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Voor','Bef');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'dd mmm ',''');
UPDATE tng_families SET divdate = REPLACE(divdate,'dd mmm ',''');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'dd mmm ',''');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'dd mmm ',''');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'dd mmm ',''');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'dd mmm ',''');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'dd mmm ',''');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'voor','Bef ');
UPDATE tng_families SET divdate = REPLACE(divdate,'voor','Bef ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'voor','Bef ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'voor','Bef ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'voor','Bef ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'voor','Bef ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'voor','Bef');



UPDATE tng_families SET marrdate = REPLACE(marrdate,'Na','Aft ');
UPDATE tng_families SET divdate = REPLACE(divdate,'Na','Aft ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Na','Aft ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Na','Aft ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Na','Aft ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Na','Aft ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Na','Aft');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'na','Aft ');
UPDATE tng_families SET divdate = REPLACE(divdate,'na','Aft ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'na','Aft ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'na','Aft ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'na','Aft ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'na','Aft ');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'na','Aft');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'* ',''');
UPDATE tng_families SET divdate = REPLACE(divdate,'* ',''');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'* ',''');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'* ',''');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'* ',''');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'* ',''');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'* ',''');


UPDATE tng_families SET marrdate = REPLACE(marrdate,'t1','t 1');
UPDATE tng_families SET divdate = REPLACE(divdate,'t1','t 1');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'t1','t 1');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'t1','t 1');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'t1','t 1');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'t1','t 1');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'t1','t 1');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'?','');
UPDATE tng_families SET divdate = REPLACE(divdate,'?','');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'?','');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'?','');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'?','');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'?','');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'?','');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'Mrt','Mar');
UPDATE tng_families SET divdate = REPLACE(divdate,'Mrt','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Mrt','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Mrt','Mar');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Mrt','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Mrt','Mar');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'Mrt.','Mar');
UPDATE tng_families SET divdate = REPLACE(divdate,'Mrt.','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Mrt.','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Mrt.','Mar');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Mrt.','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Mrt.','Mar');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Mrt.','Mar');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Mrt','Mar');