UPDATE xf_conversation_message SET message = REPLACE(message,'http://www.domain.com','https://www.domain.com');
UPDATE xf_user_profile SET signature = REPLACE(signature,'http://www.domain.com','https://www.domain.com');
UPDATE xf_post SET message = REPLACE(message,'http://www.domain.com','https://www.domain.com');
UPDATE xf_profile_post SET message = REPLACE(message,'http://www.domain.com','https://www.domain.com');
UPDATE xf_profile_post_comment SET message = REPLACE(message,'http://www.domain.com','https://www.domain.com');