MySQL Split - 문자열 자름 처리.
MySQL 에도 split 이 있다.SUBSTRING_INDEX 1. 대상 예제 쿼리 및 결과 SELECT * FROM ( SELECT 1 AS seq, 'Welcome To JKUN.NET|^^' AS message UNION ALL SELECT 2 AS seq, 'Welcome To JKUN.NET|^^' AS message UNION ALL SELECT 3 AS seq, 'Welcome To JKUN.NET|^^' AS message ) AS EX; 2. SUBSTRING_INDEX 적용 쿼리 및 결과 SELECT seq, message, SUBSTRING_INDEX(message, '|', 1) as first, SUBSTRING_INDEX(message, '|', -1) as second FRO..
2015. 9. 21.
