UPDATE post SET pagetext = REPLACE(pagetext, 'http://www.mysite/users/', 'https://www.mysite/users/');