MariaDB 11.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION `fn_GetLevel_orig`(p_NodeKey VARCHAR(1000))
RETURNS INT
LANGUAGE SQL
BEGIN
RETURN LENGTH(p_NodeKey) - LENGTH(REPLACE(p_NodeKey, '/', '')) - 1;
END;
CREATE FUNCTION `fn_GetLevel`(p_NodeKey VARCHAR(1000))
RETURNS INT
LANGUAGE SQL
RETURN LENGTH(p_NodeKey) - LENGTH(REPLACE(p_NodeKey, '/', '')) - 1;
SELECT fn_GetLevel('asda/adasd/ads/asd')


fn_GetLevel('asda/adasd/ads/asd')


2