Urlencode/urldecode As MySQL Stored Functions
DZone's Guide to
Urlencode/urldecode As MySQL Stored Functions
Join the DZone community and get the full member experience.
Join For FreeDatabases are better when they can run themselves. CockroachDB is a SQL database that automates scaling and recovery. Check it out here.
DELIMITER ;
DROP FUNCTION IF EXISTS multiurldecode;
DELIMITER |
CREATE FUNCTION multiurldecode (s VARCHAR(4096)) RETURNS VARCHAR(4096)
DETERMINISTIC
CONTAINS SQL
BEGIN
DECLARE pr VARCHAR(4096) DEFAULT '';
IF ISNULL(s) THEN
RETURN NULL;
END IF;
REPEAT
SET pr = s;
SELECT urldecode(s) INTO s;
UNTIL pr = s END REPEAT;
RETURN s;
END;
|
DELIMITER ;Databases should be easy to deploy, easy to use, and easy to scale. If you agree, you should check out CockroachDB, a scalable SQL database built for businesses of every size. Check it out here.
Like This Article? Read More From DZone
Topics:
mysql
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}