3 m_remove_bracketed_text(str TEXT)
7 RETURN REPLACE(str, SUBSTRING(str, LOCATE('(', str), LENGTH(str) - LOCATE(')', REVERSE(str)) - LOCATE('(', str) + 2), '');
12 DROP FUNCTION IF EXISTS m_split_string;
15 m_split_string (s TEXT, del VARCHAR(10), i INT)
20 SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
24 RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;
30 DROP FUNCTION IF EXISTS m_string_segment_count;
33 m_string_segment_count(s TEXT, del VARCHAR(10))
38 SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
44 DROP FUNCTION IF EXISTS m_remove_nonalpha;
46 CREATE FUNCTION m_remove_nonalpha( s CHAR(255) ) RETURNS CHAR(255) DETERMINISTIC
48 DECLARE var1, length SMALLINT DEFAULT 1;
49 DECLARE result CHAR(255) DEFAULT '';
51 SET length = CHAR_LENGTH( s );
54 SET ch = MID( s, var1, 1 );
55 IF ch REGEXP '[[:alnum:]]' THEN
56 SET result =CONCAT(result ,ch);
60 UNTIL var1 >length END REPEAT;