{"version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fockeghem.hatenablog.jp%2Fentry%2F20080711%2Fp1\" title=\"\u300c\\%foo\u300d\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u5217\u3092\u691c\u7d22\u3059\u308b\u30af\u30a8\u30ea\u3092\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3059\u308b - ockeghem&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://ockeghem.hatenablog.jp/","categories":[],"type":"rich","provider_name":"Hatena Blog","url":"https://ockeghem.hatenablog.jp/entry/20080711/p1","provider_url":"https://hatena.blog","width":"100%","author_url":"https://blog.hatena.ne.jp/ockeghem/","title":"\u300c\\%foo\u300d\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u5217\u3092\u691c\u7d22\u3059\u308b\u30af\u30a8\u30ea\u3092\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3059\u308b","image_url":null,"blog_title":"ockeghem's blog","height":"190","description":"SQL\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u3068\u805e\u3044\u3066\u3084\u3063\u3066\u304d\u307e\u3057\u305f\u3088\u30022008-07-10 - T.Terada\u306e\u65e5\u8a18\u304b\u3089 \u4f8b\u3048\u3070\u3001\u300c\\%foo\u300d\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u5217\u3092\u691c\u7d22\u3059\u308b\u5834\u5408\u306b\u306f\u3001\u3069\u306e\u3088\u3046\u306aSQL\u6587\u3092\u66f8\u3051\u3070\u3088\u3044\u306e\u3067\u3057\u3087\u3046\u304b\u3002 \u6761\u4ef6\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002 1. DBMS\u30bd\u30d5\u30c8\u306fMySQL 2. ESCAPE\u7bc0\u306f\u4f7f\u308f\u306a\u3044 \u3010\u4e2d\u7565\u3011 \u300c\\%foo\u300d\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u5217\u3092\u691c\u7d22\u3059\u308bSQL\u6587\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002 mysql> SELECT 123 FROM dual WHERE '\\\\%foo456' LIKE '\\\\\\\\\\\\%foo%'; MySQL\u306e\u5834\u5408\u3001\u6587\u5b57\u5217\u30ea\u30c6\u30e9\u30eb\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u3068LIKE\u8ff0\u8a9e\u306e\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9(\u300c%\u300d\u3001\u300c_\u300d\u2026","published":"2008-07-11 00:00:00","author_name":"ockeghem"}