{"id":3702,"date":"2024-03-27T21:07:59","date_gmt":"2024-03-28T05:07:59","guid":{"rendered":"https:\/\/crm270s.abramjmeister.com\/?p=3702"},"modified":"2024-03-27T21:07:59","modified_gmt":"2024-03-28T05:07:59","slug":"koreadaily-db-final-sql","status":"publish","type":"post","link":"https:\/\/crm270s.mycpamytax.com\/?p=3702","title":{"rendered":"KoreaDaily.db final SQL"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background has-link-color wp-elements-1 wp-block-paragraph\"><strong>below code updates \ud55c\uae00 \uc0c1\ud638: <\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE combined_output_02\nSET field8 = field7\nWHERE field8 IS NULL;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background has-link-color wp-elements-2 wp-block-paragraph\"><strong>copy phone TEL: xxx-xxx-xxx:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE combined_output_02\nSET field9 = field5\nwhere field5 like 'TEL:%' and length(field5) = 17<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background has-link-color wp-elements-3 wp-block-paragraph\"><strong>reformat phone TEL: (xxx) xxx-xxxx:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE combined_output_02\nSET field9 = substr(field5, 1, 5) || substr(field5, 7, 3) || '-' || substr(field5, 12, 3) || '-' || substr(field5, -4) \nWHERE field5 like 'TEL%(%)%' and length(field5) = 19<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background has-link-color wp-elements-4 wp-block-paragraph\"><strong>reformat phone TEL: (xxx)xxx-xxxx:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE combined_output_02\nSET field9 = substr(field5, 1, 5) || substr(field5, 7, 3) || '-' || substr(field5, 11, 3) || '-' || substr(field5, -4)\nWHERE field5 like 'TEL%(%)%' and length(field5) = 18<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-white-color has-black-background-color has-text-color has-background has-link-color wp-elements-5 wp-block-paragraph\"><strong>repeat above for TEL: in field4 and field6<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>below code updates \ud55c\uae00 \uc0c1\ud638: copy phone TEL: xxx-xxx-xxx: reformat phone TEL: (xxx) xxx-xxxx: reformat phone TEL: (xxx)xxx-xxxx: repeat above for TEL: in field4 and field6<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[26,42],"tags":[],"class_list":["post-3702","post","type-post","status-publish","format-standard","hentry","category-codes","category--yellowpage"],"_links":{"self":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts\/3702","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3702"}],"version-history":[{"count":0,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts\/3702\/revisions"}],"wp:attachment":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}