CREATE FUNCTION ISMOBILE
(mobileNum VARCHAR(32)) RETURNS INT(32)
BEGIN
DECLARE result INT(1) DEFAULT 0;
SELECT pmsg REGEXP '^1[0-9]{8}$' INTO result ;
RETURN result;
END
CREATE FUNCTION ISMOBILE
(mobileNum VARCHAR(32)) RETURNS INT(32)
BEGIN
DECLARE result INT(1) DEFAULT 0;
SELECT pmsg REGEXP '^1[0-9]{8}$' INTO result ;
RETURN result;
END
本文标题:ISMOBILE
本文链接:https://www.haomeiwen.com/subject/zmeqnltx.html
网友评论