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=22ea79bdc382acbaf1b82cda87f14784c27085ca;hp=6998171e09b3141935a75c21cbb6477ec477fe4c;hb=4b5afa0d56bc51728c988f989f70eb29b101b619;hpb=95f8104709a840c6ff706338ea4b9d55565f182a

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
index 6998171..22ea79b 100644
--- a/sql/koha/general_functions.sql
+++ b/sql/koha/general_functions.sql
@@ -29,3 +29,17 @@ CREATE FUNCTION
     END
 $
 DELIMITER ;
+
+DROP FUNCTION IF EXISTS remove_bracketed_text;
+DELIMITER $
+CREATE FUNCTION 
+   remove_bracketed_text(str TEXT)
+   RETURNS TEXT
+   DETERMINISTIC
+    BEGIN
+    RETURN REPLACE(str, SUBSTRING(str, LOCATE('(', str), LENGTH(str) - LOCATE(')', REVERSE(str)) - LOCATE('(', str) + 2), '');
+    END
+$
+DELIMITER ;
+
+