Map sequence of numbers to corresponding letters

Question

I have an int column containing values ​​no greater than 20. I want to select the uppercase letter it corresponds to: 1=A2=B3=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?

P粉269847997 · Answer

Another MySQL-specific alternative uses elt

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

Demo

P粉055726146 · Answer

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