This is something that many board administrators want to do but aren't sure how—messing with the database directly seems dangerous to many. It is quite simple though, and you can do it all through the AdminCP.
Log into the AdminCP, and in the left-hand menu click on Import & Maintenance followed by Execute SQL Query. If you are greeted with a message that says: You are not authorized to execute SQL queries you will need to add your user ID number to the line:
$canrunqueries = ''; in the
includes/config.php file. For example, if your user ID is
1, this line will become:
$canrunqueries = '1';
Now you can run queries. To carry out a find and replace on all the post data in your board, you will need to run an SQL query ...