Monday, April 16, 2012

How to judge the character string includes the numeral

SELECT  @min_value REGEXP '^[0-9]*$ INTO v_flag_min;

IF v_flag_min = 0 THEN
   no numeral
ELSE
   numeral
END IF;

The detail description as following:
http://dev.mysql.com/doc/refman/5.1/en/regexp.html

No comments:

Post a Comment