[Mysql] - mysql SUBSTRING_INDEX 함수사용법

Mysql 2011. 11. 23. 09:11
반응형
EMAIL = asdf@tistory.com

SELECT SUBSTRING_INDEX(EMAIL, "@", 1) EMAIL1,
            SUBSTRING_INDEX(EMAIL, "@", -1) EMAIL2 
  FROM ABC 

EMAIL1 = asdf 
EMAIL2 = tistory.com 
반응형
: