<script type="text/javascript">
        jQuery(function($){
            $( "a[href^='https://yadi.sk/']" ).attr('href',function (idx, value) {
                return value+'?force_show=1';
            });
        });
</script>

preg_replace('#(https://yadi.sk/i/[\w\d]+)#is',"$1?force_show=1",$text);

DROP FUNCTION IF EXISTS `change_link`;

CREATE FUNCTION `change_link`(original TEXT)
RETURNS text
    DETERMINISTIC
BEGIN
  DECLARE endpos INTEGER;
  DECLARE startpos  INTEGER;
  DECLARE url VARCHAR(100);

  SET startpos=LOCATE('https://yadi.sk',original);
  SET endpos=startpos+18;

  WHILE  SUBSTR(original,endpos,1) REGEXP '[A-Za-z0-9 ]' DO
    SET endpos=endpos+1;
  END WHILE;
    SET url=SUBSTR(original ,startpos,endpos-startpos);
    RETURN  REPLACE(original ,url,CONCAT(url,'?force_show=1'));
  END;

UPDATE dle_post SET short_story = change_link(short_story);
UPDATE dle_post SET full_story = change_link(full_story);