Control Flow

Case (when)

# NOTE YOU - CANNOT - USE - ; - WHEN IN THE - SELECT - PART OF A STATMENT 

# PLEASE JUST LOOK HERE YOU CANNOT!!!!!!!!!!!!

case otherVal # when val must be equal to otherVal
when val then code;
when val then code;
else code;
end when;

case
when val = 1 then code;
when val = 2 then code;
else code;
end when;

If - TRY AND AVOID THIS!!!

if condition then code;
else if condition then code;
else if condition then code;
else code;
end if;