how to use if else in mysql code example

Example: mysql if else

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