网站数据库批量替换代码高亮代码

update blog_posts set `post_content` = replace(`post_content`,'[sourcecode]','<pre class="prettyprint linenums">') where 1=1;

update blog_posts set `post_content` = replace(`post_content`,'[/sourcecode]','</pre>') where 1=1;