Data Architecture & Design
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment