Projekt Adressbücher/Datenbank

update entry set lastname =  concat(substring(lastname,9), ', von der')  where lastname like 'von der %';
update entry set lastname =  concat(substring(lastname,9), ', von den')  where lastname like 'von den %';
update entry set lastname =  concat(substring(lastname,5), ', von')  where lastname like 'von %';

update entry set firstname =replace(firstname,', Freiherr von',''), lastname =concat( lastname, ', Freiherr von') where firstname like '%, Freiherr von';
update entry set firstname =replace(firstname,', Freifrau von',''), lastname =concat( lastname, ', Freifrau von') where firstname like '%, Freifrau von';
update entry set firstname =replace(firstname,', Freiin von',''), lastname =concat( lastname, ', Freiin von') where firstname like '%, Freiin von';
update entry set firstname =replace(firstname,', Graf von',''), lastname =concat( lastname, ', Graf von') where firstname like '%, Graf von';
update entry set firstname =replace(firstname,', Gräfin von',''), lastname =concat( lastname, ', Gräfin von') where firstname like '%, Gräfin von';
update entry set firstname =replace(firstname,', von',''), lastname =concat( lastname, ', von') where firstname like '%, von';

update entry set firstname =replace(firstname,' Freiherr von',''), lastname =concat( lastname, ', Freiherr von') where firstname like '% Freiherr von';
update entry set firstname =replace(firstname,' Freifrau von',''), lastname =concat( lastname, ', Freifrau von') where firstname like '% Freifrau von';
update entry set firstname =replace(firstname,' Freiin von',''), lastname =concat( lastname, ', Freiin von') where firstname like '% Freiin von';
update entry set firstname =replace(firstname,' Graf von',''), lastname =concat( lastname, ', Graf von') where firstname like '% Graf von';
update entry set firstname =replace(firstname,' Gräfin von',''), lastname =concat( lastname, ', Gräfin von') where firstname like '% Gräfin von';
update entry set firstname =replace(firstname,' von',''), lastname =concat( lastname, ', von') where firstname like '% von';