or would this be better?

Code
update UBB_POSTS set POST_BODY = replace(
POST_BODY, 'http://vannin.com/',
'https://www.vanning.com/');

"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"