Skip to content

Instantly share code, notes, and snippets.

@pierophp

pierophp/mysql_split_str.sql

Created July 13, 2016 15:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pierophp/5a1e85767019ff71c8326a7c79bb6c9a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pierophp/5a1e85767019ff71c8326a7c79bb6c9a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_split_str.sql
delimiter $$
CREATE FUNCTION `SPLIT_STR`(
x VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS varchar(255) CHARSET utf8 COLLATE utf8_unicode_ci
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
CHAR_LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
delim, '')
$$
@pierophp

pierophp commented Jul 13, 2016

Copy link
Copy Markdown
Author

Usage:

SELECT SPLIT_STR('My String', ' ', 1);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment