SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) --phpfensi.com DETERMINISTIC BEGIN DECLARE iStart, iEnd, iLength int;
函數2:
CREATE FUNCTION `strip_tags`($str text) RETURNS text BEGIN DECLARE $start, $end INT DEFAULT 1; LOOP
//以上例程會輸出： Test paragraph. Other text <p>Test paragraph.</p> <a href="#fragment">Other text</a>。
