[Mysql] - mysql SUBSTRING_INDEX 함수사용법

EMAIL = asdf@tistory.com

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

EMAIL1 = asdf 
EMAIL2 = tistory.com