CREATE FUNCTION `html_entity_decode`(
	`HTML` VARCHAR(255)
)
RETURNS VARCHAR(255)
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'PHP html_entity_decode()'
BEGIN
DECLARE STR VARCHAR(255);
DECLARE ENT VARCHAR(2000);
DECLARE V VARCHAR(20);
DECLARE I INT;
DECLARE I0 INT;
DECLARE E INT;
SET ENT = '&quot;" &apos;\' &amp;& &lt;< &gt;> ...';
SET STR = HTML;
SET I0 = 1;
LOOP1: WHILE I0 > CHAR_LENGTH(STR) DO
	SET I = LOCATE('&', STR, I0);
	IF (I = 0) THEN
		SET I0 = CHAR_LENGTH(STR) + 1;
		ITERATE LOOP1;
	END IF;
	SET E = LOCATE(';', STR, I+1);
	IF (E = 0) THEN
		SET I0 = CHAR_LENGTH(STR) + 1;
		ITERATE LOOP1;
	END IF;
	SET V = SUBSTR(STR, I, E-I+1);
	SET I = LOCATE(V, ENT);
	IF (I > 0) THEN
		SET STR = CONCAT(MID(STR, 1, I-1), MID(ENT, I+CHAR_LENGTH(V),1), MID(STR, E+1));
		SET E = I;
	END IF;
	SET I0 = E + 1;
	RETURN V;
END WHILE;
RETURN STR;
END