Recetas Código: SQL

De Daniel Pecos

Split de una cadena o campo

CREATE FUNCTION strSplit(
  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, '');

Ejemplo:

select strSplit("a|bb|ccc|dd", '|', 3) as third;
+-------+
| third |
+-------+
| ccc   |
+-------+

Fuente: http://love2coding.blogspot.com/2009/04/mysql-split-delimited-strings-functions.html