Correction Dates

From TNG_Wiki
Jump to navigation Jump to search

This query corrects a number of mistakes your users or you might have made entering dates. (Part 1, the page became too long)

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_people SET birthdate = REPLACE(birthdate,'JAN','Jan');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'FEB','Feb');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'MAR','Mar');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'APR','Apr');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'MAY','May');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'JUN','Jun');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'JUL','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,'MAR','Mar');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'APR','Apr');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'MAY','May');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'JUN','Jun');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'JUL','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,'MAR','Mar');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'APR','Apr');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'MAY','May');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'JUN','Jun');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'JUL','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 deathdate = REPLACE(deathdate,'JAN','Jan');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'FEB','Feb');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'MAR','Mar');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'APR','Apr');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'MAY','May');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'JUN','Jun');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'JUL','Jul');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'AUG','Aug');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'SEP','Sep');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'OCT','Oct');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'NOV','Nov');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'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,'MAR','Mar');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'APR','Apr');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'MAY','May');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'JUN','Jun');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'JUL','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,'-1-',' Jan ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-2-',' Feb ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-3-',' Mar ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-4-',' Apr ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-5-',' May ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-6-',' Jun ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-7-',' Jul ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-8-',' Aug ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-9-',' Sep ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-10-',' Oct ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-11-',' Nov ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'-12-',' Dec ');

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

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


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

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

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

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

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

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

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

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

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

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

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

UPDATE tng_people SET birthdate = REPLACE(birthdate,'±','Abt');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'±','Abt');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'±','Abt');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'±','Abt');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'±','Abt');


UPDATE tng_people SET birthdate = REPLACE(birthdate,'Ca.','Abt ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Ca.','Abt ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Ca.','Abt ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Ca.','Abt ');
UPDATE tng_people SET birthdate = REPLACE(birthdate,'Ca,','Abt ');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Ca,','Abt ');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Ca,','Abt ');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Ca,','Abt ');

UPDATE tng_people SET birthdate = REPLACE(birthdate,'Okt.','Oct');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'Okt.','Oct');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'Okt.','Oct');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'Okt.','Oct');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'Okt.','Oct');

UPDATE tng_people SET birthdate = REPLACE(birthdate,'July','Jul');
UPDATE tng_people SET altbirthdate = REPLACE(altbirthdate,'July','Jul');
UPDATE tng_people SET deathdate = REPLACE(deathdate,'July','Jul');
UPDATE tng_people SET burialdate = REPLACE(burialdate,'July','Jul');
UPDATE tng_events SET eventdate = REPLACE(eventdate,'July','Jul');

UPDATE tng_families SET marrdate = REPLACE(marrdate,'JAN','Jan');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'FEB','Feb');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'MAR','Mar');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'APR','Apr');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'MAY','May');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'JUN','Jun');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'JUL','Jul');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'AUG','Aug');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'SEP','Sep');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'OCT','Oct');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'NOV','Nov');
UPDATE tng_families SET marrdate = REPLACE(marrdate,'DEC','Dec');

UPDATE tng_families SET divdate = REPLACE(divdate,'JAN','Jan');
UPDATE tng_families SET divdate = REPLACE(divdate,'FEB','Feb');
UPDATE tng_families SET divdate = REPLACE(divdate,'MAR','Mar');
UPDATE tng_families SET divdate = REPLACE(divdate,'APR','Apr');
UPDATE tng_families SET divdate = REPLACE(divdate,'MAY','May');
UPDATE tng_families SET divdate = REPLACE(divdate,'JUN','Jun');
UPDATE tng_families SET divdate = REPLACE(divdate,'JUL','Jul');
UPDATE tng_families SET divdate = REPLACE(divdate,'AUG','Aug');
UPDATE tng_families SET divdate = REPLACE(divdate,'SEP','Sep');
UPDATE tng_families SET divdate = REPLACE(divdate,'OCT','Oct');
UPDATE tng_families SET divdate = REPLACE(divdate,'NOV','Nov');
UPDATE tng_families SET divdate = REPLACE(divdate,'DEC','Dec');


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