1 DROP FUNCTION IF EXISTS split_string;
4 split_string (s TEXT, del VARCHAR(10), i INT)
9 SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
13 RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;
19 DROP FUNCTION IF EXISTS string_segment_count;
22 string_segment_count(s TEXT, del VARCHAR(10))
27 SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;