Which code snippet from a stored procedure should be rewritten as a CASE statement?
IF var1 = 1 THEN SET varA = var1; ELSEIF var2 = 2 THEN SET varA = var2; ELSEIF var3 = 3 THEN SET varA = var3; ELSE SET varA = var4; END IF;
IF var1 = var2 THEN SET varA = var1; ELSEIF var2 = var3 THEN SET varA = var2; ELSEIF var3 = var4 THEN SET varA = var3; ELSE SET varA = var4; END IF;
IF var1 = 1 THEN SET varA = var1; ELSEIF var1 = 2 THEN SET varA = var2; ELSEIF var1 = 3 THEN SET varA = var3; ELSE SET varA = var4; END IF;
IF var1 THEN SET varA = var1; ELSEIF var2 THEN SET varA = var2; ELSEIF var3 THEN SET varA = var3; ELSE SET varA = var4; END IF;