Advertisement
Guest User

Untitled

a guest
Nov 21st, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.66 KB | None | 0 0
  1. DELIMITER $$
  2. CREATE FUNCTION  `regex_replace`(pattern VARCHAR(1000),replacement VARCHAR(1000),original VARCHAR(1000))
  3.  
  4. RETURNS VARCHAR(1000)
  5. DETERMINISTIC
  6. BEGIN
  7.  DECLARE temp VARCHAR(1000);
  8.  DECLARE ch VARCHAR(1);
  9.  DECLARE i INT;
  10.  SET i = 1;
  11.  SET temp = '';
  12.  IF original REGEXP pattern THEN
  13.   loop_label: LOOP
  14.    IF i>CHAR_LENGTH(original) THEN
  15.     LEAVE loop_label;  
  16.    END IF;
  17.    SET ch = SUBSTRING(original,i,1);
  18.    IF NOT ch REGEXP pattern THEN
  19.     SET temp = CONCAT(temp,ch);
  20.    ELSE
  21.     SET temp = CONCAT(temp,replacement);
  22.    END IF;
  23.    SET i=i+1;
  24.   END LOOP;
  25.  ELSE
  26.   SET temp = original;
  27.  END IF;
  28.  RETURN temp;
  29. END$$
  30. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement