how we can use if statement in mysql query code example

Example: mysql if else

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