mysql过滤html标签

最新推荐文章于 2024-08-04 11:37:41 发布

xlb_123

最新推荐文章于 2024-08-04 11:37:41 发布

阅读量1.5k

点赞数

分类专栏：数据库

原文链接：https://blog.csdn.net/qq_27811247/article/details/81001854

版权

数据库专栏收录该内容

27 篇文章 0 订阅

订阅专栏

CREATE  FUNCTION `fnStripTags`( Dirty text(4000) ) RETURNS varchar(4000) CHARSET utf8
BEGIN
	DECLARE log_bin_trust_function_creators int;
	DECLARE iStart int;
	DECLARE iEnd int;
	DECLARE iLength int;
	SET  log_bin_trust_function_creators=1;

    WHILE Locate( '<', Dirty ) > 0 And Locate( '>', Dirty, Locate( '<', Dirty )) > 0 DO
      BEGIN
        SET iStart = Locate( '<', Dirty ), iEnd = Locate( '>', Dirty, Locate('<', Dirty ));
        SET iLength = ( iEnd - iStart) + 1;
        IF iLength > 0 THEN
          BEGIN
            SET Dirty = Insert( Dirty, iStart, iLength, '');
          END;
        END IF;
      END;
    END WHILE;

    RETURN Dirty;

END


测试
SELECT fnStripTags('this <html>is <b>a test</b>, nothing more</html>');