"from base 10 to base 26 only with letters so that 26 will be aa" Code Answer

this stored function converts a single int to base26:

drop function if exists `base10to26`;
delimiter ;;

create function `base10to26`(`thenumber` int(11) unsigned) 
returns varchar(20) reads sql data
begin
    declare coltxt varchar(20);
    declare value  int(11);
    set coltxt = '';

    repeat
        set value  = thenumber % 26;
        if value = 0 then set value = 26; end if;
        set thenumber = (thenumber - value) / 26;
        set coltxt = concat(char(value+64), coltxt);
    until thenumber = 0 end repeat;

    return coltxt;
end;;
delimiter ;

By Jotan on April 2 2022