mysql replace函数备忘
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://', 'https://' ) where post_content like "%http://%"
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://', 'https://' ) where post_content like "%http://%"