From 95f8104709a840c6ff706338ea4b9d55565f182a Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Fri, 7 Feb 2020 09:41:16 -0500
Subject: [PATCH] counting segments of string by delimiter

---
 sql/koha/general_functions.sql |   14 +++++++++++++-
 1 files changed, 13 insertions(+), 1 deletions(-)

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
index 83f2c4c..6998171 100644
--- a/sql/koha/general_functions.sql
+++ b/sql/koha/general_functions.sql
@@ -16,4 +16,16 @@ CREATE FUNCTION
 $
 DELIMITER ;
 
-
+DROP FUNCTION IF EXISTS string_segment_count;
+DELIMITER $
+CREATE FUNCTION 
+   string_segment_count(s TEXT, del VARCHAR(10))
+   RETURNS TEXT
+   DETERMINISTIC
+    BEGIN
+        DECLARE n INT ;
+        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
+        RETURN n;
+    END
+$
+DELIMITER ;
-- 
1.7.2.5