The ASCII() function allows you to identify the numeric value of the first character in a string.
mysql> mysql> mysql> SELECT ASCII('book'); +---------------+ | ASCII('book') | +---------------+ | 98 | +---------------+ 1 row in set (0.00 sec) mysql>