14 lines
300 B
MySQL
14 lines
300 B
MySQL
|
CREATE OR REPLACE FUNCTION splitadd (instring VARCHAR(255))
|
||
|
|
RETURNS INTEGER
|
||
|
|
NO EXTERNAL ACTION
|
||
|
|
F1: BEGIN ATOMIC
|
||
|
|
|
||
|
|
declare first INTEGER;
|
||
|
|
declare second INTEGER;
|
||
|
|
|
||
|
|
set first = REGEXP_SUBSTR(instring, '[0-9]+',1,1);
|
||
|
|
set second = REGEXP_SUBSTR(instring, '[0-9]+',1,2);
|
||
|
|
|
||
|
|
return first + second;
|
||
|
|
END
|