drop function if exists iffunction
//
create function iffunction(p_inparam INT) returns VARCHAR(10)
begin

   declare l_value VARCHAR(30);

   if p_inparam between 1 and 10 then

      set l_value := 'First Condition';
   
   elseif p_inparam between 10 and 20 then
   
      set l_value := 'Second Condition';

   else 
   
      set l_value := 'Third Condition';
   
   end if;

   return l_value;

end
//