{"id":433,"date":"2016-04-06T23:52:32","date_gmt":"2016-04-06T14:52:32","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=433"},"modified":"2016-04-06T23:52:51","modified_gmt":"2016-04-06T14:52:51","slug":"eliminate-korean","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/04\/06\/eliminate-korean\/","title":{"rendered":"Eliminate Korean MySql function"},"content":{"rendered":"

CREATE<\/b><\/span> DEFINER<\/b>=<\/span>`cosmos`@<\/span>`%` FUNCTION<\/b><\/span> `onlyHanja`(<\/span>`iName` text<\/b><\/span> )<\/span><\/p>\n

RETURNS<\/b> varchar<\/b><\/span>(4000<\/span>) CHARSET<\/b> utf8<\/b><\/span><\/p>\n

LANGUAGE<\/b> SQL<\/b><\/span><\/p>\n

NOT<\/b> DETERMINISTIC<\/b><\/p>\n

CONTAINS<\/b> SQL<\/b><\/p>\n

SQL<\/b> SECURITY<\/b> DEFINER<\/b><\/p>\n

COMMENT<\/b> ”<\/span><\/p>\n

BEGIN<\/b><\/p>\n

declare<\/b> iChar<\/span> varchar<\/b><\/span>(<\/span>1<\/span>);<\/span><\/p>\n

declare<\/b> oName<\/span> text<\/b><\/span>;<\/span><\/p>\n

declare<\/b> i<\/span> INT<\/b><\/span> DEFAULT<\/b><\/span> 1<\/span>;<\/span><\/p>\n

SET<\/b><\/span> oName =<\/span> iName;<\/span><\/p>\n

WHILE<\/b> i<\/span> <=<\/span> length<\/b><\/span>(<\/span>iName<\/span>)<\/span> DO<\/b><\/p>\n

SET<\/b><\/span> iChar =<\/span> SUBSTRING<\/b><\/span>(<\/span>iName,<\/span>i,<\/span>1<\/span>)<\/span> ;<\/span><\/p>\n

IF<\/b><\/span> iChar<\/span> between<\/b> ‘\uac00’<\/span> and<\/b> ‘\ud7a3’<\/span> THEN<\/b><\/p>\n

SET<\/b> oName<\/span> = replace<\/b>(oName<\/span>,iChar<\/span>,”<\/span>) ;<\/p>\n

END<\/b> IF<\/b><\/span> ;<\/p>\n

SET<\/b> i<\/span> = i<\/span> + 1<\/span>;<\/p>\n

END<\/b><\/span> WHILE<\/b>;<\/span><\/p>\n

SET<\/b> oName<\/span> = replace<\/b>(oName<\/span>,‘(‘<\/span>,”<\/span>);<\/p>\n

SET<\/b> oName<\/span> = replace<\/b>(oName<\/span>,‘)’<\/span>,”<\/span>);<\/p>\n

RETURN<\/b> (oName<\/span>);<\/p>\n

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

CREATE DEFINER=`cosmos`@`%` FUNCTION `onlyHanja`(`iName` text ) RETURNS varchar(4000) CHARSET utf8 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT ” BEGIN declare iChar varchar(1); declare oName text; declare i INT DEFAULT 1; SET oName = iName; WHILE i <= length(iName) DO SET iChar = SUBSTRING(iName,i,1) ; IF iChar between ‘\uac00’ and ‘\ud7a3’ THEN SET […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-433","post","type-post","status-publish","format-standard","hentry","category-about-linux"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=433"}],"version-history":[{"count":2,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/433\/revisions"}],"predecessor-version":[{"id":435,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/433\/revisions\/435"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}