Mega Code Archive

 

Categories / MySQL / String

 

ASCII(SUBSTRING(database,1,1))

mysql> mysql> mysql> select ASCII(SUBSTRING('database',1,1)); +----------------------------------+ | ASCII(SUBSTRING('database',1,1)) | +----------------------------------+ |                              100 | +----------------------------------+ 1 row in set (0.00 sec) mysql>