sql function with if code example

Example 1: if inside select mysql

SELECT IF(1>3,'true','false');

Example 2: if else sql

IF Boolean_expression
BEGIN
    -- Statement block executes when the Boolean expression is TRUE
END
ELSE
BEGIN
    -- Statement block executes when the Boolean expression is FALSE
END