Posted on

SET post_content = ( Replace (post_content, ‘src=”http://’, ‘src=”//’) ) WHERE Instr(post_content, ‘jpeg’) > 0 OR Instr(post_content, ‘jpg’) > 0 OR Instr(post_content, ‘gif’) > 0 OR Instr(post_content, ‘png’) > 0;

Posted on

SET post_content = ( Replace (post_content, “src=’http://”, “src=’//”) ) WHERE Instr(post_content, ‘jpeg’) > 0 OR Instr(post_content, ‘jpg’) > 0 OR Instr(post_content, ‘gif’) > 0 OR Instr(post_content, ‘png’) > 0;