Querys zum ändern der Sonderzeichen in der WordPress-Datenbank.
Erstellt von Hollii
http://hollii.de
---------------------------------------------------------------

UPDATE wp_categories SET category_description = replace(category_description, 'ä', 'ä');
UPDATE wp_categories SET category_description = replace(category_description, 'Ä', 'Ä');
UPDATE wp_categories SET category_description = replace(category_description, 'ü', 'ü');
UPDATE wp_categories SET category_description = replace(category_description, 'Ãœ', 'Ü');
UPDATE wp_categories SET category_description = replace(category_description, 'ö', 'ö');
UPDATE wp_categories SET category_description = replace(category_description, 'Ö', 'Ö');
UPDATE wp_categories SET category_description = replace(category_description, 'ß', 'ß');
UPDATE wp_categories SET category_description = replace(category_description, 'ß', 'ß');
UPDATE wp_categories SET category_description = replace(category_description, '°', '°');
UPDATE wp_categories SET category_description = replace(category_description, '©', '©');
UPDATE wp_categories SET category_description = replace(category_description, '€', '€');

UPDATE wp_categories SET cat_name = replace(cat_name, 'ä', 'ä');
UPDATE wp_categories SET cat_name = replace(cat_name, 'Ä', 'Ä');
UPDATE wp_categories SET cat_name = replace(cat_name, 'ü', 'ü');
UPDATE wp_categories SET cat_name = replace(cat_name, 'Ãœ', 'Ü');
UPDATE wp_categories SET cat_name = replace(cat_name, 'ö', 'ö');
UPDATE wp_categories SET cat_name = replace(cat_name, 'Ö', 'Ö');
UPDATE wp_categories SET cat_name = replace(cat_name, 'ß', 'ß');
UPDATE wp_categories SET cat_name = replace(cat_name, 'ß', 'ß');
UPDATE wp_categories SET cat_name = replace(cat_name, '°', '°');
UPDATE wp_categories SET cat_name = replace(cat_name, '©', '©');
UPDATE wp_categories SET cat_name = replace(cat_name, '€', '€');

UPDATE wp_comments SET comment_author = replace(comment_author, 'ä', 'ä');
UPDATE wp_comments SET comment_author = replace(comment_author, 'Ä', 'Ä');
UPDATE wp_comments SET comment_author = replace(comment_author, 'ü', 'ü');
UPDATE wp_comments SET comment_author = replace(comment_author, 'Ãœ', 'Ü');
UPDATE wp_comments SET comment_author = replace(comment_author, 'ö', 'ö');
UPDATE wp_comments SET comment_author = replace(comment_author, 'Ã-', 'Ö');
UPDATE wp_comments SET comment_author = replace(comment_author, 'ß', 'ß');
UPDATE wp_comments SET comment_author = replace(comment_author, 'ß', 'ß');
UPDATE wp_comments SET comment_author = replace(comment_author, '°', '°');
UPDATE wp_comments SET comment_author = replace(comment_author, '©', '©');
UPDATE wp_comments SET comment_author = replace(comment_author, '€', '€');

UPDATE wp_comments SET comment_content = replace(comment_content, 'ä', 'ä');
UPDATE wp_comments SET comment_content = replace(comment_content, 'Ä', 'Ä');
UPDATE wp_comments SET comment_content = replace(comment_content, 'ü', 'ü');
UPDATE wp_comments SET comment_content = replace(comment_content, 'Ãœ', 'Ü');
UPDATE wp_comments SET comment_content = replace(comment_content, 'ö', 'ö');
UPDATE wp_comments SET comment_content = replace(comment_content, 'Ö', 'Ö');
UPDATE wp_comments SET comment_content = replace(comment_content, 'ß', 'ß');
UPDATE wp_comments SET comment_content = replace(comment_content, 'ß', 'ß');
UPDATE wp_comments SET comment_content = replace(comment_content, '°', '°');
UPDATE wp_comments SET comment_content = replace(comment_content, '©', '©');
UPDATE wp_comments SET comment_content = replace(comment_content, '€', '€');

UPDATE wp_links SET link_description = replace(link_description, 'ä', 'ä');
UPDATE wp_links SET link_description = replace(link_description, 'Ä', 'Ä');
UPDATE wp_links SET link_description = replace(link_description, 'ü', 'ü');
UPDATE wp_links SET link_description = replace(link_description, 'Ãœ', 'Ü');
UPDATE wp_links SET link_description = replace(link_description, 'ö', 'ö');
UPDATE wp_links SET link_description = replace(link_description, 'Ã-', 'Ö');
UPDATE wp_links SET link_description = replace(link_description, 'ß', 'ß');
UPDATE wp_links SET link_description = replace(link_description, 'ß', 'ß');
UPDATE wp_links SET link_description = replace(link_description, '°', '°');
UPDATE wp_links SET link_description = replace(link_description, '©', '©');
UPDATE wp_links SET link_description = replace(link_description, '€', '€');

UPDATE wp_links SET link_name = replace(link_name, 'ä', 'ä');
UPDATE wp_links SET link_name = replace(link_name, 'Ä', 'Ä');
UPDATE wp_links SET link_name = replace(link_name, 'ü', 'ü');
UPDATE wp_links SET link_name = replace(link_name, 'Ãœ', 'Ü');
UPDATE wp_links SET link_name = replace(link_name, 'ö', 'ö');
UPDATE wp_links SET link_name = replace(link_name, 'Ö', 'Ö');
UPDATE wp_links SET link_name = replace(link_name, 'ß', 'ß');
UPDATE wp_links SET link_name = replace(link_name, 'ß', 'ß');
UPDATE wp_links SET link_name = replace(link_name, '°', '°');
UPDATE wp_links SET link_name = replace(link_name, '©', '©');
UPDATE wp_links SET link_name = replace(link_name, '€', '€');

UPDATE wp_posts SET post_content = replace(post_content, 'ä', 'ä');
UPDATE wp_posts SET post_content = replace(post_content, 'Ä', 'Ä');
UPDATE wp_posts SET post_content = replace(post_content, 'ü', 'ü');
UPDATE wp_posts SET post_content = replace(post_content, 'Ãœ', 'Ü');
UPDATE wp_posts SET post_content = replace(post_content, 'ö', 'ö');
UPDATE wp_posts SET post_content = replace(post_content, 'Ö', 'Ö');
UPDATE wp_posts SET post_content = replace(post_content, 'ß', 'ß');
UPDATE wp_posts SET post_content = replace(post_content, 'ß', 'ß');
UPDATE wp_posts SET post_content = replace(post_content, '°', '°');
UPDATE wp_posts SET post_content = replace(post_content, '©', '©');
UPDATE wp_posts SET post_content = replace(post_content, '€', '€');

UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'ä', 'ä');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'Ä', 'Ä');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'ü', 'ü');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'Ãœ', 'Ü');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'ö', 'ö');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'Ã-', 'Ö');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'ß', 'ß');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, 'ß', 'ß');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, '°', '°');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, '©', '©');
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, '€', '€');

UPDATE wp_posts SET post_title = replace(post_title, 'ä', 'ä');
UPDATE wp_posts SET post_title = replace(post_title, 'Ä', 'Ä');
UPDATE wp_posts SET post_title = replace(post_title, 'ü', 'ü');
UPDATE wp_posts SET post_title = replace(post_title, 'Ãœ', 'Ü');
UPDATE wp_posts SET post_title = replace(post_title, 'ö', 'ö');
UPDATE wp_posts SET post_title = replace(post_title, 'Ö', 'Ö');
UPDATE wp_posts SET post_title = replace(post_title, 'ß', 'ß');
UPDATE wp_posts SET post_title = replace(post_title, 'ß', 'ß');
UPDATE wp_posts SET post_title = replace(post_title, '°', '°');
UPDATE wp_posts SET post_title = replace(post_title, '©', '©');
UPDATE wp_posts SET post_title = replace(post_title, '€', '€');

UPDATE wp_terms SET name = replace(name, 'ä', 'ä');
UPDATE wp_terms SET name = replace(name, 'Ä', 'Ä');
UPDATE wp_terms SET name = replace(name, 'ü', 'ü');
UPDATE wp_terms SET name = replace(name, 'Ãœ', 'Ü');
UPDATE wp_terms SET name = replace(name, 'ö', 'ö');
UPDATE wp_terms SET name = replace(name, 'Ö', 'Ö');
UPDATE wp_terms SET name = replace(name, 'ß', 'ß');
UPDATE wp_terms SET name = replace(name, 'ß', 'ß');
UPDATE wp_terms SET name = replace(name, '°', '°');
UPDATE wp_posts SET name = replace(name, '©', '©');
UPDATE wp_terms SET name = replace(name, '€', '€');

UPDATE wp_term_taxonomy SET description = replace(description, 'ä', 'ä');
UPDATE wp_term_taxonomy SET description = replace(description, 'Ä', 'Ä');
UPDATE wp_term_taxonomy SET description = replace(description, 'ü', 'ü');
UPDATE wp_term_taxonomy SET description = replace(description, 'Ãœ', 'Ü');
UPDATE wp_term_taxonomy SET description = replace(description, 'ö', 'ö');
UPDATE wp_term_taxonomy SET description = replace(description, 'Ö', 'Ö');
UPDATE wp_term_taxonomy SET description = replace(description, 'ß', 'ß');
UPDATE wp_term_taxonomy SET description = replace(description, 'ß', 'ß');
UPDATE wp_term_taxonomy SET description = replace(description, '°', '°');
UPDATE wp_term_taxonomy SET description = replace(description, '©', '©');
UPDATE wp_term_taxonomy SET description = replace(description, '€', '€');