{"id":8589,"date":"2013-09-24T21:12:22","date_gmt":"2013-09-24T12:12:22","guid":{"rendered":"http:\/\/twitter-382477609444995073-post"},"modified":"2017-06-13T03:10:16","modified_gmt":"2017-06-12T18:10:16","slug":"sql-not-equal-does-not-contain-null","status":"publish","type":"post","link":"https:\/\/arison.jp\/blog\/2013\/09\/24\/sql-not-equal-does-not-contain-null\/","title":{"rendered":"\u3010SQL\u3011 != \u306b\u306f null \u306f\u542b\u307e\u308c\u306a\u3044"},"content":{"rendered":"<p><span class=\"font20px\">NULL\u306f\u7279\u6b8a\u306a\u5024\u3002<\/span><\/p>\n<p>SQL\u306ewhere\u53e5\u306e != \u3068 null \u306b\u306f\u6ce8\u610f\u3002<br \/>\n<span class=\"font20px\">hoge != &#8216;1&#8217;<\/span><br \/>\n<span class=\"font24px\">\u3053\u306e\u6642\u3001hoge\u304cnull \u306e\u5834\u5408\u306f<strong>\u5bfe\u8c61\u306b\u306a\u3089\u306a\u3044<\/strong>\u3002<\/span><\/p>\n<p><span class=\"font24px\"><strong>hoge\u306f&#8217;1&#8217;\u304b&#8217;0&#8217;\u3057\u304b\u3053\u3093\u3060\u308d\u3068\u601d\u3063\u3066null\u6765\u305f\u3089\u3001null\u306e\u30c7\u30fc\u30bf\u304c\u5bfe\u8c61\u306b\u306a\u3089\u306a\u304f\u3066\u30db\u30b2\u30a8\u3063\u3066\u611f\u3058\u3002<\/strong><\/span><br \/>\nnull\u30c1\u30a7\u30c3\u30af\u306f\u5225\u306b\u5fc5\u8981\u3002<\/p>\n<p>NULL\u306f \u300c\u5217\u540d = NULL\u300d \u3084 \u300c\u5217\u540d <> NULL\u300d \u3068\u3044\u3063\u305f\u901a\u5e38\u306e\u6bd4\u8f03\u6f14\u7b97\u5b50\u3092\u7528\u3044\u305f\u65b9\u6cd5\u3067\u306f\u691c\u7d22\u3067\u304d\u306a\u3044\u3002<br \/>\n<span class=\"font20px\">NULL\u3092\u5bfe\u8c61\u3068\u3057\u3066\u691c\u7d22\u3059\u308b\u5834\u5408\u306f\u3001IS NULL\u6f14\u7b97\u5b50<\/span><\/p>\n<p><!--more--><\/p>\n<p>[sql]<br \/>\nSELECT \u5217\u540d1, \u5217\u540d2, &#8230;<br \/>\nFROM \u30c6\u30fc\u30d6\u30eb\u540d<br \/>\nWHERE \u5217\u540d IS NULL<br \/>\n[\/sql]<\/p>\n<p>\u3082\u3057\u304f\u306fIS NOT NULL\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3002<\/p>\n<p>[sql]<br \/>\nSELECT \u5217\u540d1, \u5217\u540d2, &#8230;<br \/>\nFROM \u30c6\u30fc\u30d6\u30eb\u540d<br \/>\nWHERE \u5217\u540d IS NOT NULL<br \/>\n[\/sql]<\/p>\n<p><span class=\"font24px\">\u3063\u3066\u3044\u3046\u304b\u3001\u30d5\u30e9\u30b0\u306a\u30891\u304b0\u3067\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u30920\u304f\u3089\u3044\u306b\u3057\u3068\u3044\u3066<br \/>\n notNull\u5236\u7d04 \u3064\u3051\u3068\u3051\u3070\u3044\u3044\u3093\u3058\u3083\u306a\u3044\u3067\u3059\u304b\uff1f<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>NULL\u306f\u7279\u6b8a\u306a\u5024\u3002 SQL\u306ewhere\u53e5\u306e != \u3068 null \u306b\u306f\u6ce8\u610f\u3002 hoge != &#8216;1&#8217; \u3053\u306e\u6642\u3001hoge\u304cnull \u306e\u5834\u5408\u306f\u5bfe\u8c61\u306b\u306a\u3089\u306a\u3044\u3002 hoge\u306f&#8217;1&#8217; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":24491,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"status","meta":{"footnotes":""},"categories":[6,9],"tags":[212,282],"class_list":["post-8589","post","type-post","status-publish","format-status","has-post-thumbnail","hentry","category-programming","category-work","tag-db","tag-sql","post_format-post-format-status"],"_links":{"self":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts\/8589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/comments?post=8589"}],"version-history":[{"count":0,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts\/8589\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/media\/24491"}],"wp:attachment":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/media?parent=8589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/categories?post=8589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/tags?post=8589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}