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
FROM (
	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

) AS EX_SPLIT;

대단한건 아니지만 까먹으니 포스팅을 할 수밖에;;