1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| delimiter |
CREATE FUNCTION METTER0(s VARCHAR(2000)) RETURNS VARCHAR(2000)
DETERMINISTIC
BEGIN
DECLARE someLimit INT;
DECLARE str VARCHAR(2000);
DECLARE toFind VARCHAR(2000);
DECLARE co VARCHAR(2000);
SET co=A;
SET toFind = s ;
SET someLimit =100;
SET someLimit = someLimit -1;
SET toFind = SUBSTRING(toFind,open);
SET close = locate(',',toFind);
SET str =(select substring(trim(substring_index(Title,'sur',-1)),1,3) as n1 );
IF (select(str)like'ZAG,TUN,TOZ,TAT,SOS,SIL,SFX,SBO,RNC,BAR,BEJ,BIZ,BSC,GAB,GAF,JEN,KAI,KAS,KEB,KEF,MAH,MED,MON,NAB')=1 THEN update incident set test=(select substring(trim(substring_index(Test,'sur',-1)),1,3) as n1 ) WHERE Affected_CI in('other ci','Other CI');
ELSE IF (select substring(trim(substring_index(description,'du',-1)),1,3))=(ZAG,TUN,TOZ,TAT,SOS,SIL,SFX,SBO,RNC,BAR,BEJ,BIZ,BSC,GAB,GAF,JEN,KAI,KAS,KEB,KEF,MAH,MED,MON,NAB))=1 THEN update incident set test=(select substring(trim(substring_index(Test,'du',-1)),1,3) as n1 ) WHERE Affected_CI in('other ci','Other CI');
ELSE IF (select substring(trim(substring_index(description,':',-1)),1,3))=(ZAG,TUN,TOZ,TAT,SOS,SIL,SFX,SBO,RNC,BAR,BEJ,BIZ,BSC,GAB,GAF,JEN,KAI,KAS,KEB,KEF,MAH,MED,MON,NAB))=1 THEN SET co=update incident set test=(select substring(trim(substring_index(description,'du',-1)),1,3) as n1 ) WHERE Affected_CI in('other ci','Other CI');
ELSE IF (select substring(trim(substring_index(description,'BSC',-6)),1,3))=(ZAG,TUN,TOZ,TAT,SOS,SIL,SFX,SBO,RNC,BAR,BEJ,BIZ,BSC,GAB,GAF,JEN,KAI,KAS,KEB,KEF,MAH,MED,MON,NAB))=1 THEN SET co=update incident set test=(select substring(trim(substring_index(description,'BSC',-6)),1,3) as n1 ) WHERE Affected_CI in('other ci','Other CI');
ELSE co ='';
SET toFind = SUBSTRING(toFind,close+1);
END IF;
END WHILE;
return co;
END |
delimiter; |
Partager