{"id":98752,"date":"2025-02-23T16:07:35","date_gmt":"2025-02-23T12:37:35","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/ucwords-di-mysql-53fg\/"},"modified":"2025-02-23T16:07:35","modified_gmt":"2025-02-23T12:37:35","slug":"ucwords-di-mysql-53fg","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/ucwords-di-mysql-53fg\/","title":{"rendered":"ucwords di mysql – \u062c\u0627\u0645\u0639\u0647 dev"},"content":{"rendered":"
\n


ucwords \u06cc\u0627 propercase \u062f\u0631 mysql<\/p>\n

\n
DELIMITER<\/span> $$<\/span>\n\nCREATE<\/span> FUNCTION<\/span> ProperCase<\/span>(<\/span>str<\/span> VARCHAR<\/span>(<\/span>255<\/span>))<\/span> RETURNS<\/span> VARCHAR<\/span>(<\/span>255<\/span>)<\/span>\nDETERMINISTIC<\/span>\nBEGIN<\/span>\n    DECLARE<\/span> i<\/span> INT<\/span> DEFAULT<\/span> 1<\/span>;<\/span>\n    DECLARE<\/span> len<\/span> INT<\/span> DEFAULT<\/span> CHAR_LENGTH<\/span>(<\/span>str<\/span>);<\/span>\n    DECLARE<\/span> result<\/span> VARCHAR<\/span>(<\/span>255<\/span>)<\/span> DEFAULT<\/span> ''<\/span>;<\/span>\n\n    WHILE<\/span> i<\/span> <=<\/span> len<\/span> DO<\/span>\n        SET<\/span> result<\/span> =<\/span> CONCAT<\/span>(<\/span>result<\/span>,<\/span>\n            IF<\/span>(<\/span>i<\/span> =<\/span> 1<\/span> OR<\/span> SUBSTRING<\/span>(<\/span>str<\/span>,<\/span> i<\/span> -<\/span> 1<\/span>,<\/span> 1<\/span>)<\/span> =<\/span> ' '<\/span>,<\/span> UPPER<\/span>(<\/span>SUBSTRING<\/span>(<\/span>str<\/span>,<\/span> i<\/span>,<\/span> 1<\/span>)),<\/span> LOWER<\/span>(<\/span>SUBSTRING<\/span>(<\/span>str<\/span>,<\/span> i<\/span>,<\/span> 1<\/span>)))<\/span>\n        );<\/span>\n        SET<\/span> i<\/span> =<\/span> i<\/span> +<\/span> 1<\/span>;<\/span>\n    END<\/span> WHILE<\/span>;<\/span>\n\n    RETURN<\/span> result<\/span>;<\/span>\nEND<\/span> $$<\/span>\n\nDELIMITER<\/span> ;<\/span>\n\n\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0633\u067e\u0633 \u0627\u06cc\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n
\n
\nUPDATE<\/span> wilayah<\/span>\nSET<\/span> kabupaten<\/span> =<\/span> ProperCase<\/span>(<\/span>kabupaten<\/span>);<\/span>\n\n\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
ucwords \u06cc\u0627 propercase \u062f\u0631 mysql DELIMITER $$ CREATE FUNCTION ProperCase(str VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE i INT DEFAULT 1; DECLARE len INT DEFAULT CHAR_LENGTH(str); DECLARE result VARCHAR(255) DEFAULT ”; WHILE i <= len DO SET result = CONCAT(result, IF(i = 1 OR SUBSTRING(str, i – 1, 1) = ‘ ‘, UPPER(SUBSTRING(str, i, 1)), LOWER(SUBSTRING(str, …<\/p>\n","protected":false},"author":2,"featured_media":98753,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-98752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/98752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=98752"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/98752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/98753"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=98752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=98752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=98752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}