Breaking News: Grepper is joining You.com. Read the official announcement!

mysql split string by delimiter

The Digital Envious Emu answered on February 13, 2023 Popularity 9/10 Helpfulness 3/10

answer mysql split string by delimiter

related String split in MySQL

mysql split string by delimiter

Comment

CREATE FUNCTION `split_string`(string_to_split VARCHAR(255), delimiter VARCHAR(12), part_number INT) RETURNS varchar(255) CHARSET utf8
    DETERMINISTIC
BEGIN
	DECLARE result VARCHAR(255);
	SET result = SUBSTRING_INDEX(SUBSTRING_INDEX(string_to_split, delimiter, part_number), delimiter, -1);
	RETURN result;
END

Popularity 9/10 Helpfulness 3/10 Language javascript

Source: blog.fedecarg.com

Tags: delimiter mysql sql string

Link to this answer
Share Copy Link

Contributed on Feb 13 2023

The Digital Envious Emu

0 Answers Avg Quality 2/10

Closely Related Answers

String split in MySQL

Comment

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(colors, ',', 1), ',', -1) as colorfirst,
       SUBSTRING_INDEX(SUBSTRING_INDEX(colors, ',', 2), ',', -1) as colorsecond
....
       SUBSTRING_INDEX(SUBSTRING_INDEX(colors, ',', n), ',', -1) as colornth
  FROM product;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link