{"id":688,"date":"2022-12-22T10:30:34","date_gmt":"2022-12-22T01:30:34","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=688"},"modified":"2022-12-22T10:30:35","modified_gmt":"2022-12-22T01:30:35","slug":"mysql-null-or-%eb%ac%b8%ec%9e%90-%ec%bb%ac%eb%9f%bc-%ec%84%9c%eb%a1%9c-%eb%b9%84%ea%b5%90%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=688","title":{"rendered":"[Mysql] null or \ubb38\uc790 \uceec\ub7fc \uc11c\ub85c \ube44\uad50\ud558\uae30"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT * FROM `\ud14c\uc774\ube14 \uc774\ub984` WHERE NOT `\uceec\ub7fc1` &amp;lt;=&gt; `\uceec\ub7fc2`\n<\/pre><\/div>\n\n\n<p>\uae30\ubcf8\uc801\uc778 LIKE\ub098 = \ub85c \ube44\uad50\ud558\uba74 \ud55c\ucabd \uac12\uc774 null\uc778 \uacbd\uc6b0 true\ub098 false\uac00 \uc544\ub2cc null\uc744 \ub9ac\ud134\ud55c\ub2e4.<\/p>\n\n\n\n<p><code>\uceec\ub7fc1<\/code> &lt;=> <code>\uceec\ub7fc2<\/code><\/p>\n\n\n\n<p>\uc704 \ubd80\ubd84\uc73c\ub85c \uc801\uc6a9\ud574\uc11c \ubcf4\uba74 null\uc744 \ud3ec\ud568\ud574\uc11c \uc11c\ub85c \ub2e4\ub974\uba74 0(FALSE)\uc744 \ub9ac\ud134\ud558\uace0, \uac19\uc73c\uba74 1(TRUE)\uc744 \ub9ac\ud134\ud55c\ub2e4.<\/p>\n\n\n\n<p>\uc11c\ub85c \ub2e4\ub97c\ub54c TRUE\ub97c \ub9ac\ud134\ud558\ub824\uba74 \uc55e\uc5d0 NOT\uc744 \ubd99\uc5ec\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uae30\ubcf8\uc801\uc778 LIKE\ub098 = \ub85c \ube44\uad50\ud558\uba74 \ud55c\ucabd \uac12\uc774 null\uc778 \uacbd\uc6b0 true\ub098 false\uac00 \uc544\ub2cc null\uc744 \ub9ac\ud134\ud55c\ub2e4. \uceec\ub7fc1 &lt;=> \uceec\ub7fc2 \uc704 \ubd80\ubd84\uc73c\ub85c \uc801\uc6a9\ud574\uc11c \ubcf4\uba74 null\uc744 \ud3ec\ud568\ud574\uc11c \uc11c\ub85c \ub2e4\ub974\uba74 0(FALSE)\uc744 \ub9ac\ud134\ud558\uace0, \uac19\uc73c\uba74 1(TRUE)\uc744 \ub9ac\ud134\ud55c\ub2e4. \uc11c\ub85c \ub2e4\ub97c\ub54c TRUE\ub97c \ub9ac\ud134\ud558\ub824\uba74 \uc55e\uc5d0 NOT\uc744 \ubd99\uc5ec\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[9],"tags":[15,162,181,184,205,343],"class_list":["post-688","post","type-post","status-publish","format-standard","hentry","category-sql","tag-15","tag-mysql","tag-181","tag-diff","tag-query","tag-null"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=688"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/688\/revisions"}],"predecessor-version":[{"id":689,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/688\/revisions\/689"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}