{"id":6078,"date":"2020-10-02T16:38:12","date_gmt":"2020-10-02T07:38:12","guid":{"rendered":"https:\/\/nsme.red\/wp\/?p=6078"},"modified":"2020-10-02T16:38:12","modified_gmt":"2020-10-02T07:38:12","slug":"%e6%ad%a3%e8%a6%8f%e8%a1%a8%e7%8f%be%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%9f%e6%a4%9c%e7%b4%a2%e3%80%80regexp","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/search\/6078\/","title":{"rendered":"\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3063\u305f\u691c\u7d22\u3000regexp"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">regexp\u95a2\u6570\u3092\u4f7f\u3046<br>\u884c\u982d\u691c\u7d22\u306e\u5834\u5408\u3000regexp &#8216;^Y\u3000^\u884c\u982d\u306e\u30de\u30fc\u30af<br>\u884c\u672b\u306e\u5834\u5408\u3000regexp &#8216;da$&#8217;\u3000\uff04\u884c\u672b\u306e\u30de\u30fc\u30af<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WHERE meta_key regexp '^\u9069\u6027\u8a3a\u65ad_&#91;0-9+]_\u5e74\u6708\u65e5$'<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><span class=\"has-inline-color has-vivid-purple-color\">.      \u4efb\u610f\u306e1\u6587\u5b57\u306b\u4e00\u81f4\u3057\u307e\u3059\u3002\n[...]  \u62ec\u5f27\u5185\u306e\u3044\u305a\u308c\u304b\u306e\u6587\u5b57\u306b\u4e00\u81f4\n       [abc] \u306a\u3089 a b c \u306e\u3044\u305a\u308c\u304b\u306b\u4e00\u81f4\n       [a-z] \u306a\u3089 a \u304b\u3089 z \u306e\u3044\u305a\u308c\u304b\u306b\u4e00\u81f4\n       [^a-z] \u306a\u3089 a \u304b\u3089 z \u4ee5\u5916\u306b\u4e00\u81f4\n*      \u76f4\u524d\u306e\u6587\u5b57\u306e 0 \u56de\u4ee5\u4e0a\u306e\u7e70\u308a\u8fd4\u3057\u306b\u4e00\u81f4\n+      \u76f4\u524d\u306e\u6587\u5b57\u306e 1 \u56de\u4ee5\u4e0a\u306e\u7e70\u308a\u8fd4\u3057\u306b\u4e00\u81f4\n?      \u76f4\u524d\u306e\u6587\u5b57\u306e 0 \u56de\u304b 1 \u56de\u306b\u4e00\u81f4\nab|cd|ef  ab \u307e\u305f\u306f cd \u307e\u305f\u306f ef \u306e\u6587\u5b57\u5217\u306b\u4e00\u81f4\n^      \u6587\u5b57\u5217\u306e\u5148\u982d\u306b\u4e00\u81f4\n$      \u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u4e00\u81f4\n(abc)  \u4f8b\u3048\u3070 (abc)* \u306e\u3088\u3046\u306b\u4f7f\u7528\n{n,m}  {n} \u76f4\u524d\u306e\u30d1\u30bf\u30fc\u30f3\u306e n \u56de\u9023\u7d9a\u306b\u4e00\u81f4\n       {n,} \u76f4\u524d\u306e\u30d1\u30bf\u30fc\u30f3\u306e n \u56de\u4ee5\u4e0a\u306e\u9023\u7d9a\u306b\u4e00\u81f4\n       {,m} \u76f4\u524d\u306e\u30d1\u30bf\u30fc\u30f3\u306e m \u56de\u4ee5\u4e0b\u306e\u9023\u7d9a\u306b\u4e00\u81f4\n       {n,m} \u76f4\u524d\u306e\u30d1\u30bf\u30fc\u30f3\u306e n\u56de\u4ee5\u4e0a m \u56de\u4ee5\u4e0b\u306e\u9023\u7d9a\u306b\u4e00\u81f4<\/span><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>regexp\u95a2\u6570\u3092\u4f7f\u3046\u884c\u982d\u691c\u7d22\u306e\u5834\u5408\u3000regexp &#8216;^Y\u3000^\u884c\u982d\u306e\u30de\u30fc\u30af\u884c\u672b\u306e\u5834\u5408\u3000regexp &#8216;da$&#8217;\u3000\uff04\u884c\u672b\u306e\u30de\u30fc\u30af . \u4efb\u610f\u306e1\u6587\u5b57\u306b\u4e00\u81f4\u3057\u307e\u3059\u3002 [&#8230;] \u62ec\u5f27\u5185\u306e\u3044\u305a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-6078","post","type-post","status-publish","format-standard","hentry","category-search"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=6078"}],"version-history":[{"count":1,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6078\/revisions"}],"predecessor-version":[{"id":6079,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6078\/revisions\/6079"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=6078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=6078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=6078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}