PostgreSQLã§æ£è¦è¡¨ç¾ã«ãƒžãƒƒãƒã—ãŸæ–‡å—ã®æŠ½å‡ºDoRuby! (ドルビー!) ã¯ç¾å ´ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€ä¸»ã«Rubyãªã©ã®æŠ€è¡“ã«é–¢ã™ã‚‹æ§˜ã€…ãªå®Ÿè·µãƒŽã‚¦ãƒã‚¦ã‚’集ã‚ãŸæŠ€è¡“æƒ…å ±ã‚µã‚¤ãƒˆã§ã™ã€‚ PostgreSQLã§ã‚‚æ£è¦è¡¨ç¾ã‚’使ãˆã‚‹ã€ãªã‚“ã¦ã“ã¨ã§ãã‚‹ã‚“ã§ã™ã‚ˆã㣠ã£ã¦ã‚ã‘ã§ã€ä»Šå›žã¯ãれをè¸ã¾ãˆã¦æ£è¦è¡¨ç¾ã«ãƒžãƒƒãƒã—ãŸæ–‡å—列を抽出ã—よã†ã¨æ€ã„ã¾ã™ã€‚ ãªã‚“ã¦ã“ãŸããªã„。 SELECT SUBSTRING(mobile_email FROM '(docomo|softbank|ezweb)') AS carrier2 , carrier FROM users ; ã“ã‚Œã§ã€ã‚るテーブルを用æ„ã—ã€å®Ÿè¡Œçµæžœã‚’ã¿ã‚‹ã¨ã€ carrier2 | carrier ----------+---------- docomo | DoCoMo docomo | DoCoMo ezweb | au softbank | SoftBank softbank | Soft
{{#tags}}- {{label}}
{{/tags}}