Update WordPress posts which may contain broken code snippets for syntax highlighting.

fix_wordpress_posts.sql

-- 1. Reset all code snippets to use '<pre><code>' as opening tags.
UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '<pre[^>]*>(<code[^>]*>)*', '<pre><code>') 
WHERE post_status = 'publish' 
	AND post_type = 'post' 
	AND post_content RLIKE '<pre[^>]*>(<code[^>]*>)*';

-- 2. Reset all closing tags.
UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '(<\/code>)*<\/pre>>', '</code></pre>') 
WHERE post_status = 'publish' 
	AND post_type = 'post' 
	AND post_content RLIKE '(<\/code>)*<\/pre>';