ZADANIE DODATKOWE

DELIMITER $$
CREATE FUNCTION rep_lace(in_string varchar(1000), prev varchar(64), new varchar(64))
RETURNS varchar(1000)
DETERMINISTIC
BEGIN
    DECLARE res varchar(1000);
    DECLARE res_1 varchar(1000);
    DECLARE res_2 varchar(1000);
    DECLARE counter int;
    DECLARE i int;
    SET res = in_string;
    SET counter = 1;
    WHILE(counter <= char_length(res)) DO
        SET i = 1;
        myloop: WHILE(i <= char_length(prev)) DO
                    IF SUBSTRING(res, counter, 1) = SUBSTRING(prev, i, 1) THEN
                        SET res = REPLACE(res, SUBSTRING(res, counter, 1), SUBSTRING(new, i, 1));
                        LEAVE myloop;
                    ELSE
                        SET i = i + 1;
                    END IF;
        END WHILE myloop;
        SET counter = counter + 1;
    END WHILE;
    RETURN res;
END$$