Guest User

Untitled

a guest
Nov 17th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. DELIMITER $$
  2. CREATE FUNCTION f_format_text(str VARCHAR (255), replacement VARCHAR(1), ply TINYINT(3), bias DECIMAL(5,2)) RETURNS VARCHAR(255)
  3. BEGIN
  4. DECLARE treshold INT;
  5. DECLARE len INT;
  6. SET len = LENGTH(str);
  7. SET treshold = FLOOR(ply*bias*len);
  8.  
  9. RETURN (
  10. SELECT REPLACE(str, SUBSTRING(str,treshold), REPEAT(replacement, ((len - treshold) + 1)))
  11. );
  12. END $$
  13. DELIMITER ;
Add Comment
Please, Sign In to add comment