Projekt Adressbücher/Datenbank: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „<source lang="sql"> update entry set lastname = concat(substring(lastname,9), ', von der') where lastname like 'von der %'; update entry set lastname = concat(...“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 18: | Zeile 18: | ||
update entry set firstname =replace(firstname,' von',''), lastname =concat( lastname, ', von') where firstname like '% von'; | update entry set firstname =replace(firstname,' von',''), lastname =concat( lastname, ', von') where firstname like '% von'; | ||
</source> | </source> | ||
[[Kategorie:Projektbetreuung Adressbuchdatenbank]] | |||
Aktuelle Version vom 12. September 2013, 16:50 Uhr
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';