Map sequence of numbers to corresponding letters

Question

I have a int column that contains values ​​no greater than 20. I want to select its corresponding uppercase letter:

1 = A
2=B
3=C
...

I don't care what happens after Z because the column does not contain larger values. Is there an easy way to convert this to single byte characters using a SQL query?

Answer 1

Another MySQL-specific alternative uses elt

select elt(col,'A','B','C','D','E','F',...);

Demo

Answer 2

Add 64 to the integer and you get the ASCII value of the letter you want.

mysql> select CHAR(1+64);
+------------+
| CHAR(1+64) |
+------------+
| A          |
+------------+

Read https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char