반응형
출처 http://cafe.naver.com/masterexcel/592
DROP FUNCTION IF EXISTS split_str;
DELIMITER $$
CREATE FUNCTION split_str(in_str text, d_char varchar(1), pos int)
RETURNS text
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(in_str, d_char, pos), d_char, -1);
$$
DELIMITER ;
select 'Shin-Osaka, Osaka, Japan', split_str('Shin-Osaka, Osaka, Japan',',',1)
반응형