{"id":1498,"date":"2012-11-21T15:27:28","date_gmt":"2012-11-21T15:27:28","guid":{"rendered":"http:\/\/galhano.com\/blog\/?p=1498"},"modified":"2012-11-21T15:27:28","modified_gmt":"2012-11-21T15:27:28","slug":"mysql-proper-case-formating-a-column","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1498","title":{"rendered":"mysql &#8216;Proper case&#8217; formating a column?"},"content":{"rendered":"<p>How to do something like:<\/p>\n<p>Proper(&#8220;GALHANO.COM&#8221;) = &#8220;Galhano.com&#8221;<\/p>\n<p>there&#8217;s no builtin function to do this but we combine CONCAT and SUBSTRING:<\/p>\n<p>[sql]CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to do something like: Proper(&#8220;GALHANO.COM&#8221;) = &#8220;Galhano.com&#8221; there&#8217;s no builtin function to do this but we combine CONCAT and SUBSTRING: [sql]CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))[\/sql]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,141,8,40],"tags":[],"class_list":["post-1498","post","type-post","status-publish","format-standard","hentry","category-code-snippets","category-databases","category-mysql","category-sql","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1498"}],"version-history":[{"count":2,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions"}],"predecessor-version":[{"id":1500,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1498\/revisions\/1500"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}