mysql存储过程正则表达式

Question

我尝试用正则表达式检查我的 IN 参数，但总是出错

BEGIN
declare clausolein varchar(255);
IF POST_FARMS is null THEN
SET clausolein=1;
ELSE IF POST_FARMS REGEXP '^[1-9]' THEN
SET clausolein=2;
ELSE
SET clausolein=3;
END IF;
SELECT clausolein;
END

Answer 1

请仔细阅读此链接:http://dev.mysql.com/doc/refman/5.7/en/if.html

13.6.5.2 IF Syntax

IF search_condition THEN statement_list
   [ELSEIF search_condition THEN statement_list] ...
   [ELSE statement_list]
END IF

然后请将以上语法与您的代码进行比较:

ELSE   IF  POST_FARMS REGEXP '^[1-9]' THEN