實用的MySQL Function: Split String

Function

    CREATE FUNCTION SPLIT_STR(    x VARCHAR(255),    delim VARCHAR(12),    pos INT  )  RETURNS VARCHAR(255)  RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),         LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),         delim, '');

Usage

SELECT SPLIT_STR(string, delimiter, position)

Example

  SELECT SPLIT_STR('a|bb|ccc|dd', '|', 3) as third;    +-------+  | third |  +-------+  | ccc   |  +-------+

轉載自：http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/