mysql database find and replace

  • elczupakabra

    (@elczupakabra)


    14 years, 3 months ago

    Hi,
    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?

The topic ‘mysql database find and replace’ is closed to new replies.