{"id":29,"date":"2025-07-19T21:37:57","date_gmt":"2025-07-19T19:37:57","guid":{"rendered":"https:\/\/baza.kajodata.com\/?p=29"},"modified":"2025-07-27T21:00:37","modified_gmt":"2025-07-27T19:00:37","slug":"komentowanie-w-where","status":"publish","type":"post","link":"https:\/\/baza.kajodata.com\/?p=29","title":{"rendered":"Komentowanie w WHERE"},"content":{"rendered":"\n<p>Kiedy testuje si\u0119 r\u00f3\u017cne warunki w klauzuli WHERE to cz\u0119sto mamy potrzeb\u0119 &#8222;wykomentowania&#8221; danego warunku by nie by\u0142 cz\u0119\u015bci\u0105 kwerendy. <\/p>\n\n\n\n<p>Problem zawsze jest z pierwszym warunkiem, bo idealnie by by\u0142o by nawet ten &#8222;pierwszy&#8221; zaczyna\u0142 si\u0119 od AND by m\u00f3c po prostu doda\u0107 &#8212; \u017ceby &#8222;wykomentowa\u0107&#8221;. <\/p>\n\n\n\n<p>Rozwi\u0105zaniem jest dodanie &#8222;warunku&#8221; 1 = 1, kt\u00f3ry poniewa\u017c zawsze jest prawdziwy nie zmienia nam kwerendy. <\/p>\n\n\n\n<p>Wtedy ten rzeczywisty pierwszy warunek zaczyna si\u0119 od AND i mo\u017cna go szybciej &#8222;wykomentowa\u0107&#8221;.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select\n  order_id\n  ,customer_id\nfrom orders\nwhere 1=1\n-- and shipping = 'First Class'\n   and year(order_date) = 2021<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">select<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  order_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  ,customer_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">from<\/span><span style=\"color: #D8DEE9FF\"> orders<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">where<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #B48EAD\">1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- and shipping = &#39;First Class&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">   <\/span><span style=\"color: #81A1C1\">and<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">year<\/span><span style=\"color: #D8DEE9FF\">(order_date) <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2021<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Je\u017celi w komentarzu mamy warto\u015bci tylko z jednej kolumny mo\u017cemy u\u017cy\u0107 operatora IN i tutaj nie ma ju\u017c potrzeby korzysta\u0107 z 1=1.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select\n  order_id\n  ,customer_id\nfrom orders\nwhere year(order_date) in (\n         2020\n        ,2021\n        ,2022\n        ,2023\n)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">select<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  order_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  ,customer_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">from<\/span><span style=\"color: #D8DEE9FF\"> orders<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">where<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">year<\/span><span style=\"color: #D8DEE9FF\">(order_date) <\/span><span style=\"color: #81A1C1\">in<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">         <\/span><span style=\"color: #B48EAD\">2020<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">        ,<\/span><span style=\"color: #B48EAD\">2021<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">        ,<\/span><span style=\"color: #B48EAD\">2022<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">        ,<\/span><span style=\"color: #B48EAD\">2023<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kiedy testuje si\u0119 r\u00f3\u017cne warunki w klauzuli WHERE to cz\u0119sto mamy potrzeb\u0119 &#8222;wykomentowania&#8221; danego warunku by nie by\u0142 cz\u0119\u015bci\u0105 kwerendy. Problem zawsze jest z pierwszym warunkiem, bo idealnie by by\u0142o by nawet ten &#8222;pierwszy&#8221; zaczyna\u0142 si\u0119 od AND by m\u00f3c po prostu doda\u0107 &#8212; \u017ceby &#8222;wykomentowa\u0107&#8221;. Rozwi\u0105zaniem jest dodanie &#8222;warunku&#8221; 1 = 1, kt\u00f3ry poniewa\u017c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[16,8,12],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-sql","tag-pl","tag-sql","tag-tekst"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=29"}],"version-history":[{"count":1,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":30,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions\/30"}],"wp:attachment":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}