pythontr.com
DELIMITER $$ DROP FUNCTION IF EXISTS `removeHTML`$$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ FUNCTION `removeHTML`(strText longtext) RETURNS longtext BEGIN declare nPos1, nPos2 int; set nPos1 = InStr(strText, "<"); While nPos1 > 0 DO set nPos2 = locate( ">", strText, nPos1 + 1); If nPos2 > 0 Then set strText = concat(Left(strText, nPos1 - 1), Mid(strText, nPos2 + 1)); End If; set nPos1 = InStr(strText, "<"); END WHILE; return strText; END$$ DELIMITER ;
Yorumlar