{ Berbagi, Menulis, Dan Mengajar } Ilmu…

DECLARE btstelepon1 INT;
SELECT LOCATE(‘+’,new.SenderNumber) INTO btstelepon1;
IF btstelepon1 > 0 THEN
SELECT REPLACE(NEW.SenderNumber,’+62′,’0′) INTO notelp;
SELECT COUNT(*) INTO jumlah FROM list_user where
no_telepon = notelp;
ELSE
SELECT NEW.SenderNumber INTO notelp;
END IF;