LIKEæã§ã®ã¨ã¹ã±ã¼ãå¦ç æ£è¦è¡¨ç¾ã®ä¸ã§ä¸çªä½¿ãããããªãããªãã¨æãã以ä¸ãã#ããã¨ã¹ã±ã¼ãæåæå®ã test_\(testã¯ä»»ææå)ã¨ããã¦ã¼ã¶ãããã¨ãã¦ããã«ãããããããå ´åããã®ã\ã(ã¨ã³ãã¼ã¯)ãã¯ã»ã¢ãã SELECT * FROM user_table WHERE user_name LIKE '%#_\\' ESCAPE '#'; ã¨ããããã«ãããESCAPEæåãæå®ãã¦ãã\ãã¯ç¹æ®æåã¨ãã¦æ±ãããã ã§ãESCAPEå¥ã使ããªãã¨ããã¨ä»¥ä¸ã®ããã«ãªãã SELECT * FROM user_table WHERE user_name LIKE '%\\_\\\\'; ããããã£ã¡ãéåæãããã©ã\\\\ã(ã¨ã³ãã¼ã¯ï¼ã¤)ã§ã\ã(ã¨ã³ãã¼ã¯ä¸ã¤)ã«ãããããã PostgreSQL8.3.0ã®ããã¥ã¡ã³ãã«ããã¨ã ã¢ã³ãã¼ã¹ã³ã¢ããã¼ã»ã³ã
{{#tags}}- {{label}}
{{/tags}}