CREATE FUNCTION `strip_tags`($str text) RETURNS text CHARSET utf8 DETERMINISTIC BEGIN DECLARE $start, $end INT DEFAULT 1; LOOP SET $start = LOCATE("<", $str, $start); IF (!$start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); IF (!$end) THEN SET $end = $start; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP; END
mysql字符串过滤掉HTML标签的函数
2017-08-09 22:38:02 来源: 网友分享