{"id":434,"date":"2007-11-07T00:00:00","date_gmt":"2007-11-06T16:00:00","guid":{"rendered":"http:\/\/www.strongd.net\/?p=434"},"modified":"2011-07-15T09:56:13","modified_gmt":"2011-07-15T01:56:13","slug":"removing-html-tags-using-mysql","status":"publish","type":"post","link":"https:\/\/www.strongd.net\/?p=434","title":{"rendered":"Removing HTML tags using mysql"},"content":{"rendered":"

Try this (ported from a T-SQL func by Robert Davis): <\/P>
\n

SET GLOBAL log_bin_trust_function_creators=1;
DROP FUNCTION IF EXISTS fnStripTags;
DELIMITER |
CREATE FUNCTION fnStripTags( Dirty varchar(4000) )
RETURNS varchar(4000)
DETERMINISTIC
BEGIN
  DECLARE iStart, iEnd, iLength int;
    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;
|
DELIMITER ;
SELECT fnStripTags(‘this <html>is <b>a test<\/b>, nothing more<\/html>’);
<\/P>
\n

<\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"

Try this (ported from a T-SQL func by Robert Davis): SET GLOBAL log_bin_trust_function_creators=1;DROP FUNCTION IF EXISTS fnStripTags;DELIMITER |CREATE FUNCTION fnStripTags( Dirty varchar(4000) )RETURNS varchar(4000)DETERMINISTIC BEGIN  DECLARE iStart, iEnd, iLength int;    WHILE Locate( ‘<‘, Dirty ) > 0 And Locate( ‘>’, Dirty, Locate( ‘<‘, Dirty )) > 0 DO      BEGIN        SET iStart = Locate( ‘<‘, Dirty … Continue reading Removing HTML tags using mysql<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[203],"class_list":["post-434","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=434"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/434\/revisions"}],"predecessor-version":[{"id":942,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/434\/revisions\/942"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}