{"id":289,"date":"2022-03-21T10:34:17","date_gmt":"2022-03-21T02:34:17","guid":{"rendered":"http:\/\/www.cgh0610.cn\/?p=289"},"modified":"2022-03-21T10:34:17","modified_gmt":"2022-03-21T02:34:17","slug":"mysql-and-or%e6%89%a7%e8%a1%8c%e9%a1%ba%e5%ba%8f","status":"publish","type":"post","link":"https:\/\/www.cgh0610.cn\/?p=289","title":{"rendered":"MySQL &#8211; AND\/OR\u6267\u884c\u987a\u5e8f"},"content":{"rendered":"<p>MySql\u4e2d,\u4f1a\u6309\u4ee5\u4e0b\u6743\u91cd\u987a\u5e8f\u6267\u884cNOT > AND > OR,\u4e14where\u540e\u9762\u5982\u679c\u6709or,or\u4f1a\u81ea\u52a8\u628a\u5de6\u53f3\u5206\u7ec4<br \/>\n\u4f8b\u5982:<br \/>\n<code>SELECT * FROM student WHERE id=10001 AND<\/code>name<code>='\u5c0fA' OR 1=1 AND<\/code>age<code>=18;<\/code><br \/>\n\u76f8\u5f53\u4e8e<br \/>\n<code>SELECT * FROM student WHERE (id=10001 AND<\/code>name<code>='\u5c0fA') OR (1=1 AND<\/code>age<code>=18);<\/code><\/p>\n<p>\u4f8b\u5982:<br \/>\n<code>select * from book where bid in (1,3,4) or  bname like 'Java%' and price = 30<\/code><br \/>\n\u76f8\u5f53\u4e8e<br \/>\n\u56e0\u4e3aMysql\u5148\u5904\u7406AND\u64cd\u4f5c\u7b26\uff0c\u6240\u4ee5\u5148\u5224\u65adbname like &#8216;Java%&#8217; and price = 30\uff0c\u6ca1\u6709\u7b26\u5408\u8be5\u6761\u4ef6\u7684\u8bb0\u5f55\uff0c\u518d\u548cbid in (1,3,4)\u505a\u6216\u8fd0\u7b97.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySql\u4e2d,\u4f1a\u6309\u4ee5\u4e0b\u6743\u91cd\u987a\u5e8f\u6267\u884cNOT > AND > OR,\u4e14where\u540e\u9762\u5982\u679c\u6709or,or\u4f1a\u81ea\u52a8\u628a\u5de6\u53f3\u5206 &hellip; <a href=\"https:\/\/www.cgh0610.cn\/?p=289\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">MySQL &#8211; AND\/OR\u6267\u884c\u987a\u5e8f<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/289"}],"collection":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=289"}],"version-history":[{"count":1,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}