SQL::Abstract 㧠LIKE ã® ESCAPE を指定ã™ã‚‹ - daily dayfloweræ£è¦è¡¨ç¾ã§ã„ㆠ^a_c.* ã¿ãŸã„ãªã®ã‚’ã²ã£ã‹ã‘よã†ã¨æ€ã£ã¦ï¼Œ my ($sql, @binds) = SQL::Abstract->new()->select( # table 'foo', # fields [ '*' ], # where { id => { LIKE => 'a_c%' }, }, ); ã¿ãŸãã‚„ã‚‹ã¨ï¼Œa_code ã ã‘ã§ãªã abc もマッãƒã—ã¦ã—ã¾ã†ç½ 。 PostgreSQL ã ã¨ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—㌠\ ã«ãªã£ã¦ã‚‹ã®ã§ï¼Œ # where { id => { LIKE => 'a\\_c%' }, }, ã®ã‚ˆã†ã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚Œã°ã„ã„（MySQL ã ã¨ã©ã†ãªã‚“ã ã‚）。 ã§ã‚‚，ãŸã¨ãˆã° SQLite ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—ãŒè¨å®šã•ã‚Œã¦ãªã„。ã ã‹ã‚‰ LIKE ãªã©ã®ã‚ã¨ã« ESCAPE を指定ã™ã‚‹ã®ãŒæœ¬ç‹ã€‚ãªã‚“ã ã‘ã©ï¼ŒSQL::Abstract ã§ãµ
{{#tags}}- {{label}}
{{/tags}}