Title: mysql database find and replace
Last modified: August 20, 2016

---

# mysql database find and replace

 *  [elczupakabra](https://wordpress.org/support/users/elczupakabra/)
 * (@elczupakabra)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/mysql-database-find-and-replace/)
 * 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.

## Tags

 * [find and replace](https://wordpress.org/support/topic-tag/find-and-replace/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [elczupakabra](https://wordpress.org/support/users/elczupakabra/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/mysql-database-find-and-replace/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics