天涯尽头无女友
此函数仅执行从字符串返回数字0-9的工作,无论您使用什么前缀或后缀,都能很好地解决您的问题。http://www.artfulsoftware.com/infotree/queries.php?&bw=1280#815复制此处以供参考:SET GLOBAL log_bin_trust_function_creators=1;DROP FUNCTION IF EXISTS digits;DELIMITER |CREATE FUNCTION digits( str CHAR(32) ) RETURNS CHAR(32)BEGIN DECLARE i, len SMALLINT DEFAULT 1; DECLARE ret CHAR(32) DEFAULT ''; DECLARE c CHAR(1); IF str IS NULL THEN RETURN ""; END IF; SET len = CHAR_LENGTH( str ); REPEAT BEGIN SET c = MID( str, i, 1 ); IF c BETWEEN '0' AND '9' THEN SET ret=CONCAT(ret,c); END IF; SET i = i + 1; END; UNTIL i > len END REPEAT; RETURN ret;END |DELIMITER ;SELECT digits('$10.00Fr'); #returns 1000