a couple of years ago I sold my vannin.com domain name, and have been using vanninG.com since.

I still have tons of old posts that contain the old url.

how would I run a sql query to find and replace ann instances of vannin.com with vanning.com in user posts?

this is what I came up with, but don't want to run it without being sure.


Code
UPDATE
    [ ubbt_POSTS ]
SET
    [ POST_BODY ] =
REPLACE
    ([ POST_BODY ], '[vannin]', '[vanning]');

"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"