drop function if exists ucfirst;
drop function if exists ucwords;

create function ucfirst (string varchar(1024)) returns varchar(1024)
return concat(upper(substring(string, 1, 1)), lower(substring(string, 2)));

delimiter #
create function ucwords (input varchar(1024)) returns varchar(1024)
begin
    set @input := input;
    set @output := "";
    tokenizer: loop
        set @idx := LOCATE(" ", @input);
        if @idx = 0 then
            set @output := concat(@output, ucfirst(@input));
            leave tokenizer;
        end if;
        set @output := concat(@output, ucfirst(substring(@input, 1, @idx)));
        set @input := substring(@input, @idx + 1);
    end loop tokenizer;
    return @output;
end#
delimiter ;

select ucwords("UNITED states Of AmERIca");