现在还有点问题，明天好好修理一下，呵呵。
UPDATE wp_posts SET post_content = replace( post_content, "[/CODE]", "[/ coolcode]" ) WHERE `post_content` LIKE '%[/CODE]%'
-- Good good study, day day up!
UPDATE wp_posts SET post_content = replace( post_content, "[/CODE]", "[/ coolcode]" ) WHERE `post_content` LIKE '%[/CODE]%'