how to write if condition within if condition for mysql code example

Example: mysql if else

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