elczupakabraHi,
I've got some problem with code formatting after phpbb3 to wordpress bbpress convert.
I want to repair all the bbcode but don't know how to do it fast.
What i mean is that I want to find and replace text in posts but each post generated slightly different code. So I've got thousands of posts with for example: "[/b:2rrz96l0]". And it differs in each post "[/b:******]"
UPDATE wpp_posts SET post_content = replace(post_content,"[/b:2rrz96l0]","[/b]") - that works for one post at a time only.
How to find various strings beginning with "[/b(somelettersandnumbers)]" and replace em with [/b]
How to do it via phpmyadmin or notepad?
