MySQL 获取某个字段中的数字

MySQL 获取某个字段中的数字，函数如下：

DELIMITER $$

USE `test` $$

DROP FUNCTION IF EXISTS `GetNum` $$

CREATE  FUNCTION `getnum` (Varstring VARCHAR (500)) RETURNS VARCHAR (30) CHARSET utf8mb4 
BEGIN
  DECLARE v_length INT DEFAULT 0 ;
  DECLARE v_Tmp VARCHAR (50) DEFAULT '' ;
  SET v_length = CHAR_LENGTH(Varstring) ;
  WHILE
    v_length > 0 DO IF (
      ASCII(MID(Varstring, v_length, 1)) > 47 
      AND ASCII(MID(Varstring, v_length, 1)) < 58
    ) 
    THEN SET v_Tmp = CONCAT(v_Tmp, MID(Varstring, v_length, 1)) ;
    END IF ;
    SET v_length = v_length - 1 ;
  END WHILE ;
  RETURN REVERSE(v_Tmp) ;
END $$

DELIMITER ;

测试：