- DROP FUNCTION IF EXISTS `noHTML`$$
- CREATE FUNCTION noHTML (dataNoHTML TEXT)
- RETURNS TEXT
- DETERMINISTIC
- BEGIN
- WHILE LOCATE("<",dataNoHTML) and LOCATE(">",dataNoHTML) DO
- SET dataNoHTML = REPLACE(dataNoHTML,SUBSTRING(dataNoHTML,LOCATE("<",dataNoHTML),LOCATE(">",dataNoHTML)-LOCATE("<",dataNoHTML)+1),"");
- END WHILE;
- RETURN dataNoHTML;
- END$$
DROP FUNCTION IF EXISTS `noHTML`$$
CREATE FUNCTION noHTML (dataNoHTML TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
WHILE LOCATE("<",dataNoHTML) and LOCATE(">",dataNoHTML) DO
SET dataNoHTML = REPLACE(dataNoHTML,SUBSTRING(dataNoHTML,LOCATE("<",dataNoHTML),LOCATE(">",dataNoHTML)-LOCATE("<",dataNoHTML)+1),"");
END WHILE;
RETURN dataNoHTML;
END$$