mysql query con elseif code example

Example: mysql if else

IF condition THEN
   statements;
ELSE
   else-statements;
END IF;