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 like this: UPDATE post SET pagetext = REPLACE (pagetext,'Vbulletin','vBulletin') WHERE pagetext LIKE '% Vbulletin%'
;
This SQL query looks through the posts for instances of Vbulletin and replaces them with vBulletin. The WHERE
clause is used...