The following is a function to find regex defined positions in a string and a procedure to break words out of a string based on regex. delimiter $$---- This function will return the first position in p_str where the regexp is true--drop function if exists regexPos $$create function regexPos( p_str TEXT, p_regex varchar(250) ) returns intBEGIN declare v_pos int; declare v_len int; set v_pos=1; set