Rodney rodneyjoyce

## MySQL function for replacing HTML entities with their actual characters
DELIMITER $$

DROP FUNCTION IF EXISTS `database`.`HTML_UnEncode`$$
CREATE DEFINER=`root`@`127.0.0.1` FUNCTION `HTML_UnEncode`(x VARCHAR(255)) RETURNS varchar(255) CHARSET latin1
BEGIN

DECLARE TextString VARCHAR(255) ;
SET TextString = x ;

#quotation mark
	DELIMITER $$

	DROP FUNCTION IF EXISTS `database`.`HTML_UnEncode`$$
	CREATE DEFINER=`root`@`127.0.0.1` FUNCTION `HTML_UnEncode`(x VARCHAR(255)) RETURNS varchar(255) CHARSET latin1
	BEGIN

	DECLARE TextString VARCHAR(255) ;
	SET TextString = x ;

	#quotation mark