{"id":130,"date":"2020-12-30T12:20:49","date_gmt":"2020-12-30T15:20:49","guid":{"rendered":"http:\/\/wiki.softgreen.com.br\/?p=130"},"modified":"2020-12-30T12:20:49","modified_gmt":"2020-12-30T15:20:49","slug":"mysql-5-x-regex-replace","status":"publish","type":"post","link":"http:\/\/wiki.softgreen.com.br\/index.php\/2020\/12\/30\/mysql-5-x-regex-replace\/","title":{"rendered":"MySQL 5.x Regex Replace"},"content":{"rendered":"\n<p>A fun\u00e7\u00e3o funciona na substitui\u00e7\u00e3o de caracteres de uma string atrav\u00e9s de um padr\u00e3o regex. O c\u00f3digo fonte da fun\u00e7\u00e3o foi encontrado em: <a rel=\"noreferrer noopener\" href=\"https:\/\/techras.wordpress.com\/2011\/06\/02\/regex-replace-for-mysql\/\" target=\"_blank\">https:\/\/techras.wordpress.com\/2011\/06\/02\/regex-replace-for-mysql\/<\/a><\/p>\n\n\n\n<p>C\u00f3digo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELIMITER $$\r\nCREATE DEFINER=root@localhost FUNCTION regex_replace_char(pattern VARCHAR(100), replacement VARCHAR(255), original VARCHAR(255)) RETURNS varchar(1000) CHARSET utf8 DETERMINISTIC\r\nBEGIN\r\nDECLARE temp VARCHAR(1000);\r\nDECLARE ch VARCHAR(1);\r\nDECLARE i INT;\nSET i = 1;\nSET temp = '';\n\nIF original REGEXP pattern THEN -- 1 = true or 0 = false\n    loop_label: LOOP \n        IF i&gt;CHAR_LENGTH(original) THEN\n            LEAVE loop_label;  \n        END IF;\n        SET ch = SUBSTRING(original,i,1);\n\n        IF NOT ch REGEXP pattern THEN\n            SET temp = CONCAT(temp,ch);\n        ELSE\n            SET temp = CONCAT(temp,replacement);\n        END IF;\n        SET i=i+1;\n    END LOOP;\nELSE\n    SET temp = original;\nEND IF;\nRETURN temp;\nEND$$\r\nDELIMITER ;<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A fun\u00e7\u00e3o funciona na substitui\u00e7\u00e3o de caracteres de uma string atrav\u00e9s de um padr\u00e3o regex. O c\u00f3digo fonte da fun\u00e7\u00e3o foi encontrado em: https:\/\/techras.wordpress.com\/2011\/06\/02\/regex-replace-for-mysql\/ C\u00f3digo:<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":2,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":218,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/posts\/130\/revisions\/218"}],"wp:attachment":[{"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wiki.softgreen.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}