Skip to content

Scripts

Jump to bottom Edit New page
aritas1 edited this page Jun 5, 2012 · 3 revisions

Update Database unescaped names

UPDATE course SET name_unescaped = replace( replace( replace( replace( replace( replace( name, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

UPDATE degree_group SET name_unescaped = replace( replace( replace( replace( replace( replace( name, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

UPDATE degree SET name_unescaped = replace( replace( replace( replace( replace( replace( name, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

UPDATE lecturer SET name_unescaped = replace( replace( replace( replace( replace( replace( name, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

UPDATE lecturer SET first_name_unescaped = replace( replace( replace( replace( replace( replace( first_name, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

UPDATE lecturer SET degree_unescaped = replace( replace( replace( replace( replace( replace( degree, 'ä', 'a'), 'Ä', 'A'), 'ö', 'o'), 'Ö', 'O'), 'ü', 'u'), 'Ü', 'U');

Add a custom footer
Add a custom sidebar

Clone this wiki locally