X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fkoha%2Fgeneral_functions.sql;fp=sql%2Fkoha%2Fgeneral_functions.sql;h=83f2c4c7a0c3873c01df6abe4bed40c197c356e6;hp=0000000000000000000000000000000000000000;hb=57538f92486509faec4ae9b7f1f34c6c552d872c;hpb=d913034e59d2cf52eeb8419dd42366909c168b7c

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
new file mode 100644
index 0000000..83f2c4c
--- /dev/null
+++ b/sql/koha/general_functions.sql
@@ -0,0 +1,19 @@
+DROP FUNCTION IF EXISTS split_string;
+DELIMITER $
+CREATE FUNCTION 
+   split_string (s TEXT, del VARCHAR(10), i INT)
+   RETURNS TEXT
+   DETERMINISTIC
+    BEGIN
+        DECLARE n INT ;
+        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
+        IF i > n THEN
+            RETURN NULL ;
+        ELSE
+            RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;        
+        END IF;
+    END
+$
+DELIMITER ;
+
+