{"title":" SQL::Abstract \u3067 LIKE \u306e ESCAPE \u3092\u6307\u5b9a\u3059\u308b","published":"2009-06-25 17:19:37","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","author_name":"dayflower","blog_title":"daily dayflower","height":"190","width":"100%","type":"rich","url":"https://dayflower.hatenablog.com/entry/20090625/1245917977","image_url":null,"description":"\u6b63\u898f\u8868\u73fe\u3067\u3044\u3046 ^a_c.* \u307f\u305f\u3044\u306a\u306e\u3092\u3072\u3063\u304b\u3051\u3088\u3046\u3068\u601d\u3063\u3066\uff0c my ($sql, @binds) = SQL::Abstract->new()->select( # table 'foo', # fields [ '*' ], # where { id => { LIKE => 'a_c%' }, }, ); \u307f\u305f\u304f\u3084\u308b\u3068\uff0ca_code \u3060\u3051\u3067\u306a\u304f abc \u3082\u30de\u30c3\u30c1\u3057\u3066\u3057\u307e\u3046\u7f60\u3002PostgreSQL \u3060\u3068\uff0c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u30a8\u30b9\u30b1\u30fc\u30d7\u6587\u5b57\u304c \\ \u306b\u306a\u3063\u3066\u308b\u306e\u3067\uff0c # where { id => { LIKE => 'a\\\\_c%' }, }, \u306e\u3088\u3046\u306b\u30a8\u30b9\u30b1\u30fc\u30d7\u3059\u308c\u3070\u3044\u3044\uff08MySQL \u3060\u3068\u3069\u3046\u306a\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdayflower.hatenablog.com%2Fentry%2F20090625%2F1245917977\" title=\" SQL::Abstract \u3067 LIKE \u306e ESCAPE \u3092\u6307\u5b9a\u3059\u308b - daily dayflower\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/dayflower/","blog_url":"https://dayflower.hatenablog.com/","categories":["perl","db","memo"],"version":"1.0"}