{"id":364,"date":"2011-11-24T08:48:34","date_gmt":"2011-11-24T00:48:34","guid":{"rendered":"https:\/\/blog.rexdf.org\/?p=364"},"modified":"2011-11-24T08:48:34","modified_gmt":"2011-11-24T00:48:34","slug":"oracle%e4%b8%adescape%e5%85%b3%e9%94%ae%e5%ad%97%e7%94%a8%e6%b3%95-%e6%8d%a2%e5%ad%97%e7%ac%a6%e7%94%a8%e6%b3%95","status":"publish","type":"post","link":"https:\/\/blog.rexdf.org\/ja\/2011\/11\/oracle%e4%b8%adescape%e5%85%b3%e9%94%ae%e5%ad%97%e7%94%a8%e6%b3%95-%e6%8d%a2%e5%ad%97%e7%ac%a6%e7%94%a8%e6%b3%95\/","title":{"rendered":"ORACLE\u4e2dESCAPE\u5173\u952e\u5b57\u7528\u6cd5 \u6362\u5b57\u7b26\u7528\u6cd5"},"content":{"rendered":"
2007\u5e7407\u670801\u65e5 \u661f\u671f\u65e5 \u4e0b\u5348 09:16<\/div>\n\n\n\n
\n
\n

ESCAPE\u7528\u6cd5<\/h3>\n

1.\u4f7f\u7528 ESCAPE \u5173\u952e\u5b57\u5b9a\u4e49\u8f6c\u4e49\u7b26\u3002\u5728\u6a21\u5f0f\u4e2d\uff0c\u5f53\u8f6c\u4e49\u7b26\u7f6e\u4e8e\u901a\u914d\u7b26\u4e4b\u524d\u65f6\uff0c\u8be5\u901a\u914d\u7b26\u5c31\u89e3\u91ca\u4e3a\u666e\u901a\u5b57\u7b26\u3002<\/span><\/p>\n

2.ESCAPE ‘escape_character’\u00a0<\/span>
\u5141\u8bb8\u5728\u5b57\u7b26\u4e32\u4e2d\u641c\u7d22\u901a\u914d\u7b26\u800c\u4e0d\u662f\u5c06\u5176\u4f5c\u4e3a\u901a\u914d\u7b26\u4f7f\u7528\u3002escape_character \u662f\u653e\u5728\u901a\u914d\u7b26\u524d\u8868\u793a\u6b64\u7279\u6b8a\u7528\u9014\u7684\u5b57\u7b26\u3002\u00a0<\/span>
<\/span>select * from a WHERE name LIKE ‘%\/%ab’ ESCAPE ‘\/’<\/span><\/span><\/p>\n


\u7ed3\u679c\u4e3a\uff1a\u00a0<\/span>
name\u00a0<\/span>
———-\u00a0<\/span>
11%ab\u00a0<\/span>
12%ab<\/p>\n


ESCAPE<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

2007\u5e7407\u670801\u65e5 \u661f\u671f\u65e5 \u4e0b\u5348 09:16 ESCAPE\u7528\u6cd5 1.\u4f7f\u7528 E … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[50],"class_list":["post-364","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-2"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/posts\/364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/comments?post=364"}],"version-history":[{"count":0,"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/posts\/364\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/media?parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/categories?post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rexdf.org\/ja\/wp-json\/wp\/v2\/tags?post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}