It is complaining about near STRCMP.
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END
Thanks in advance!
Alex