mysql stored procedure regexp

Question

i try to check my IN param with a regexp but always is a error

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

What does the error say?

Walls
– Walls

2014-04-22 13:25:48 +00:00
Commented Apr 22, 2014 at 13:25 — Walls
– Walls, Commented Apr 22, 2014 at 13:25
right syntax to use near ''

lbottoni
– lbottoni

2014-04-22 14:18:20 +00:00
Commented Apr 22, 2014 at 14:18 — lbottoni
– lbottoni, Commented Apr 22, 2014 at 14:18

krokodilko · Accepted Answer · 2014-04-22 18:29:33Z

2

Please study thoroughly this link: 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

and then please compare the above syntax with your code:

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

answered Apr 22, 2014 at 18:29

krokodilko

36.3k7 gold badges62 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql stored procedure regexp

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related