IF [condition 1] THEN
[statements to execute when condition 1 is TRUE];
ELSIF [condition 2] THEN
[statements to execute when condition 2 is TRUE];
ELSE
[statements to execute when both condition 1 & condition 2 are FALSE];
END IF;