CREATE FUNCTION fn_getCleanURLStr( str CHAR(255) ) RETURNS CHAR(255) BEGIN DECLARE i, len SMALLINT DEFAULT 1; DECLARE ret CHAR(255) DEFAULT ''; DECLARE c CHAR(1); SET len = CHAR_LENGTH( str ); REPEAT BEGIN SET c = MID( str, i, 1 ); IF c REGEXP '[[:alnum:]]' OR c = '-' THEN SET ret=CONCAT(ret,c); END IF; SET i = i + 1; END; UNTIL i > len END REPEAT; RETURN ret; END; Boxing Day Fun
Login

Connect With Us

Houses for rent Saskatoon
Categories
News
Featured Property
Fun Facts
Condo Owners
Rental Owners
Recent Posts
Scam Alert
06/05/2019
blank
Wisdom for the new year
01/03/2019
blank
Boxing Day Fun
12/27/2018
blank
Boxing Day Fun
3D Harry Potter themed puzzles
Boxing Day Fun
December 27, 2018