projects
/
migration-tools.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
83f2c4c7a0c3873c01df6abe4bed40c197c356e6
[migration-tools.git]
/
sql
/
koha
/
general_functions.sql
1
DROP FUNCTION IF EXISTS split_string;
2
DELIMITER $
3
CREATE FUNCTION
4
split_string (s TEXT, del VARCHAR(10), i INT)
5
RETURNS TEXT
6
DETERMINISTIC
7
BEGIN
8
DECLARE n INT ;
9
SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
10
IF i > n THEN
11
RETURN NULL ;
12
ELSE
13
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;
14
END IF;
15
END
16
$
17
DELIMITER ;
18
19