Skip to content

Instantly share code, notes, and snippets.

@heluvaguy
Forked from mikedamage/split_str.sql
Created September 17, 2013 21:32
Show Gist options
  • Save heluvaguy/6600952 to your computer and use it in GitHub Desktop.
Save heluvaguy/6600952 to your computer and use it in GitHub Desktop.
-- SPLIT_STR MySQL Function
-- from http://blog.fedecarg.com/2009/02/22/mysql-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, '');
/*
Example:
SELECT SPLIT_STR('a|bb|ccc|dd', '|', 3) as third;
+-------+
| third |
+-------+
| ccc |
+-------+
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment