BEGIN
DECLARE iResult tinyint DEFAULT 0;
IF ISNULL(str) THEN return 0; END IF;
IF str = '' THEN return 0; END IF;
SELECT str REGEXP '^(\-?[[:digit:]]+(\.[[:digit:]]+)?)(e(\-?[[:digit:]]+(\.[[:digit:]]+)?))?$' INTO iResult;
IF iResult = 1 THEN
RETURN 1;
ELSE
RETURN 0;
END IF;
RETURN 0;
END
DECLARE iResult tinyint DEFAULT 0;
IF ISNULL(str) THEN return 0; END IF;
IF str = '' THEN return 0; END IF;
SELECT str REGEXP '^(\-?[[:digit:]]+(\.[[:digit:]]+)?)(e(\-?[[:digit:]]+(\.[[:digit:]]+)?))?$' INTO iResult;
IF iResult = 1 THEN
RETURN 1;
ELSE
RETURN 0;
END IF;
RETURN 0;
END