qTranslate: sql command pro vymazani vsech jazykovych mutaci z DB, krome cestiny
UPDATE wp_posts SET post_content = case when LOCATE('<!--:cs-->', post_content) > 0 then SUBSTRING(post_content, LOCATE('<!--:cs-->', post_content)+10) else post_content end;
UPDATE wp_posts SET post_content = case when LOCATE('<!--:-->', post_content) > 0 then SUBSTRING(post_content, 1, LOCATE('<!--:-->', post_content)-1) else post_content end;
UPDATE wp_posts SET post_title = case when LOCATE('<!--:cs-->', post_title) > 0 then SUBSTRING(post_title, LOCATE('<!--:cs-->', post_title)+10) else post_title end;
UPDATE wp_posts SET post_title = case when LOCATE('<!--:-->', post_title) > 0 then SUBSTRING(post_title, 1, LOCATE('<!--:-->', post_title)-1) else post_title end;
UPDATE wp_posts SET post_excerpt = case when LOCATE('<!--:cs-->', post_excerpt) > 0 then SUBSTRING(post_excerpt, LOCATE('<!--:cs-->', post_excerpt)+10) else post_excerpt end;
UPDATE wp_posts SET post_excerpt = case when LOCATE('<!--:-->', post_excerpt) > 0 then SUBSTRING(post_excerpt, 1, LOCATE('<!--:-->', post_excerpt)-1) else post_excerpt end;
UPDATE wp_terms SET name = case when LOCATE('<!--:cs-->', name) > 0 then SUBSTRING(name, LOCATE('<!--:cs-->', name)+10) else name end;
UPDATE wp_terms SET name = case when LOCATE('<!--:-->', name) > 0 then SUBSTRING(name, 1, LOCATE('<!--:-->', name)-1) else name end;