ããpostgreå®æ¹ææ¡£ä¸å¯¹similar to å likeç说æï¼
ããstring LIKE pattern [ ESCAPE escape-character ]
ããæ¯ä¸ª pattern å®ä¹ä¸ä¸ªå串çéåã å¦æ该 string å
å«å¨ pattern 代表çå串éåéï¼é£ä¹ LIKE 表达å¼è¿åçãå¦æ pattern ä¸å
å«ç¾åå·æè
ä¸å线ï¼é£ä¹è¯¥æ¨¡å¼åªä»£è¡¨å®æ¬èº«ï¼è¿æ¶å LIKE çè¡ä¸ºå°±è±¡çå·æä½ç¬¦ãå¨ pattern éçä¸å线ï¼_ï¼ä»£è¡¨ï¼å¹é
ï¼ä»»ä½å个å符ï¼èä¸ä¸ªç¾åå·ï¼%ï¼å¹é
ä»»ä½é¶ææ´å¤å符é¿çå串ã
ããä¾å¦ï¼
ãã'abc' LIKE 'abc' true
ãã'abc' LIKE 'a%' true
ãã'abc' LIKE '_b_' true
ãã'abc' LIKE 'c' false
ãã
ããstring SIMILAR TO pattern [ESCAPE escape-character]
ããSIMILARTO æ ¹æ®èªå·±ç模å¼æ¯å¦å¹é
ç»å®å串èè¿åçæè
åãå®å LIKE é常类似ï¼åªä¸è¿å®ä½¿ç¨SQLæ åå®ä¹çæ£å表达å¼ç解模å¼ãSQL æ åçæ£å表达å¼æ¯å¨LIKE表示æ³åæ®éçæ£å表达å¼è¡¨ç¤ºæ³ä¹é´å¤æªç交åã类似 LIKEï¼SIMILAR TO æä½ç¬¦åªæå¨å®ç模å¼å¹é
æ´ä¸ªå串çæ¶åæè½æåï¼è¿ä¸ç¹åæ®éçæ£å表达å¼çä¹ æ¯ä¸åï¼å¨æ®éçæ£å表达å¼éï¼æ¨¡å¼å¹é
å串çä»»æé¨åãå LIKE 类似çå°æ¹è¿æï¼SIMILAR TO ä½¿ç¨ _ å % ä½ä¸ºåå«ä»£è¡¨ä»»æå串åä»»æå串å符çéé
符ãï¼è¿äºå POSIX æ£å表达å¼éç . å .* å
¼å®¹ï¼é¤äºè¿äºä» LIKE åç¨çåè½ä¹å¤ï¼ SIMILAR TO æ¯æä¸é¢è¿äºä» POSIX æ£å表达å¼åç¨ç模å¼å¹é
å
å符ï¼
ãã· | æ è¯éæ©ï¼ä¸¤ä¸ªåéä¹ä¸ï¼ã
ãã· * 表示éå¤åé¢ç项é¶æ¬¡ææ´å¤æ¬¡ã
ãã· + 表示éå¤åé¢ç项ä¸æ¬¡ææ´å¤æ¬¡ã
ãã· å¯ä»¥ä½¿ç¨åæ¬å¼§ () æ项ç»åæä¸ä¸ªé»è¾é¡¹ã
ãã· ä¸ä¸ªæ¹æ¬å¼§è¡¨è¾¾å¼ [...] 声æä¸ä¸ªåç¬¦è¡¨ï¼ å°±å POSIX æ£å表达å¼ä¸æ ·ã
ããä¾å¦ï¼
ãã'abc' SIMILAR TO 'abc' true
ãã'abc' SIMILAR TO 'a' false
ãã'abc' SIMILAR TO '%(b|d)%' true
ãã'abc' SIMILAR TO '(b|c)%' false
温馨提示:答案为网友推荐,仅供参考