Re: ADVANCED TRIGGER need help

[bram putra]

thanks for ur encouraging reply PB

finally i can get them using mysqludf sys_exec, after installation and other things. successfully i use this syntax:

do sys_exec('echo error >> /tmp/out3.txt');

and i start to build simple trigger for my SMS GATEWAY

delimiter //
CREATE TRIGGER test.autorespond1 AFTER INSERT on test.inbox
FOR EACH ROW BEGIN
IF SUBSTRING(New.TextDecoded,1,4) = "TEST"
THEN
do sys_exec('echo true >> /tmp/out3.txt');
ELSE
do sys_exec('echo false >> /tmp/out3.txt');
end if;
end;
//

from explanation above, when i send SMS to my server using word TEST, the system successfully add TRUE words into file /tmp/out3.txt

but i want somethin more, so when i send SMS using word TEST SUCCESS, the system will add string SUCCESS into /tmp/out3.txt

Can u help me again?
Thx