The basic mysql syntax (which can be launched from Phpmyadmin Sql Tab) is this: UPDATE table SET field_name = REPLACE(field_name, ‘tony’, ‘TONY’)For example, to change an old url link to a new one in the body of forum posts: UPDATE smf_messages SET body = REPLACE(body, ‘myoldurl.com’, ‘mynewurl.com’)
The basic mysql syntax (which can be launched from Phpmyadmin Sql Tab) is this: UPDATE table SET field_name = REPLACE(field_name, ‘tony’, ‘TONY’)For example, to change an old url link to a new one in the body of forum posts: UPDATE smf_messages SET body = REPLACE(body, ‘myoldurl.com’, ‘mynewurl.com’)