DefiantX added a post in a topic: Replacing something (post content)
[quote name='ΑndyF' timestamp='1345303482' post='2298257']
1. Take a database backup, important do not skip this step.
2. Go to System > Cache Management > Delete the post cache, otherwise newer posts won't be effected
3. Go to Support > SQL Management > SQL Toolbox > Scroll down to the manual query window
And run that, changing old word and new word for what you needed.
Alternative method: Use the badword filter to replace (exact) one word with another.
Thank you very much! This worked :)
UPDATE posts SET post=REPLACE(post, 'old word', 'new word')