{"id":1696,"date":"2020-10-27T10:16:25","date_gmt":"2020-10-27T09:16:25","guid":{"rendered":"https:\/\/blog.mhasin.eu\/?p=1696"},"modified":"2020-10-27T10:16:43","modified_gmt":"2020-10-27T09:16:43","slug":"mysql-check-if-ip-is-in-subnet","status":"publish","type":"post","link":"https:\/\/blog.mhasin.eu\/?p=1696","title":{"rendered":"MYSQL check if ip is in subnet"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT (-1 << (33 - INSTR(BIN(INET_ATON(\"255.255.254.0\")), \"0\"))) & INET_ATON(\"193.87.98.1\") = INET_ATON(\"193.87.90.0\") <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Nieje v rosahu<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"797\" height=\"267\" src=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-8.png\" alt=\"\" class=\"wp-image-1697\" srcset=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-8.png 797w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-8-300x101.png 300w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-8-768x257.png 768w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Je v rozsahu<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"983\" height=\"269\" src=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-9.png\" alt=\"\" class=\"wp-image-1698\" srcset=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-9.png 983w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-9-300x82.png 300w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/10\/obrazok-9-768x210.png 768w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/figure>\n<div class=\"pdf24Plugin-cp\"> \t<form name=\"pdf24Form0\" method=\"post\" action=\"https:\/\/doc2pdf.pdf24.org\/wordpress.php\" target=\"pdf24PopWin\" onsubmit=\"var pdf24Win = window.open('about:blank', 'pdf24PopWin', 'resizable=yes,scrollbars=yes,width=600,height=250,left='+(screen.width\/2-300)+',top='+(screen.height\/3-125)+''); pdf24Win.focus(); if(typeof pdf24OnCreatePDF === 'function'){void(pdf24OnCreatePDF(this,pdf24Win));}\"> \t\t<input type=\"hidden\" name=\"blogCharset\" value=\"Cw1x07UAAA==\" \/><input type=\"hidden\" name=\"blogPosts\" value=\"MwQA\" \/><input type=\"hidden\" name=\"blogUrl\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLQUA\" \/><input type=\"hidden\" name=\"blogName\" value=\"c\/LxdwcA\" \/><input type=\"hidden\" name=\"blogValueEncoding\" value=\"gzdeflate base64\" \/><input type=\"hidden\" name=\"postId_0\" value=\"MzSzNAMA\" \/><input type=\"hidden\" name=\"postTitle_0\" value=\"840MDvRRSM5ITc5WyExTyCxQyCxWyMxTKC5NykstAQA=\" \/><input type=\"hidden\" name=\"postLink_0\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLdW3L7A1NLM0AwA=\" \/><input type=\"hidden\" name=\"postAuthor_0\" value=\"y00syfcwNAIA\" \/><input type=\"hidden\" name=\"postDateTime_0\" value=\"MzIwMtA1NNA1MlcwNLACIiNTAA==\" \/><input type=\"hidden\" name=\"postContent_0\" value=\"tZJfb5swFMXf+ymu7kMFUsAGloBbiLRNecg0MWnN++QSD1j5Y2HTpPn0M+Yl0yqtEh2SZV+BzzmX+7tJ5SCgaLhSGZ6k99j0xZNX9EeB23Tatg+7r7vPB3C8AG4bfT8tcKIIPNjnD4fvzqd97uzz3eHHx8O33MFwvfbn9cGn6LorwGlz4Za38h6uvgxY5CexzxI\/QBey117RSQJSYoOkxETd3pgnlX8llnzg5cBlhdu8Fr8EPMPQK16N5tZ852ddjq+0Wre8FKDqi\/AaPpRT23VbQtPzY92VGTb88oJwFCaCrbl66QqEU33UVYYxixEqUZeVzjDcmEINRYaV1lLdEWIsSr+tuKo7X4zEmBZ9p0WnySgnB0VCGlISUNI\/DvzSP3mJL7sSgTdGD6\/C2phesGGzhRJ6sQuY8KcVLFDxIkrPAQ2smjkvVIs3yTlcx3O2TXJCOxbTPx91vwKn5WfP\/ve7Kbo8uxBQ+mxMbYVADCLzlN9AyZcZkcv\/Z4Ql0TUjbDEj7F+MJO\/BiHUBE37RVJllJAnfBRE2IxLQtyBikl8hYqs\/EfkN\" \/> \t\t<a href=\"https:\/\/www.pdf24.org\" target=\"_blank\" title=\"www.pdf24.org\" rel=\"nofollow\"><img src=\"https:\/\/blog.mhasin.eu\/wp-content\/plugins\/pdf24-post-to-pdf\/img\/pdf_32x32.png\" alt=\"\" border=\"0\" height=\"32\" \/><\/a> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<span class=\"pdf24Plugin-cp-text\">Send article as PDF<\/span> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<input class=\"pdf24Plugin-cp-input\" style=\"margin: 0px;\" type=\"text\" name=\"sendEmailTo\" placeholder=\"Enter email address\" \/> \t\t<input class=\"pdf24Plugin-cp-submit\" style=\"margin: 0px;\" type=\"submit\" value=\"Send\" \/> \t<\/form> <\/div>","protected":false},"excerpt":{"rendered":"Nieje v rosahu Je v rozsahu \u00a0\u00a0 Send article as PDF \u00a0\u00a0\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"arc_restricted_post":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1696","post","type-post","status-publish","format-standard","hentry","category-programovanie"],"_links":{"self":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1696"}],"version-history":[{"count":1,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1696\/revisions"}],"predecessor-version":[{"id":1699,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1696\/revisions\/1699"}],"wp:attachment":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}