mysql > select concat( ' 0x ' , hex( 123 )); + -- ----------------------+ | concat( ' 0x ' , hex( 123 )) | + -- ----------------------+ | 0x7B | + -- ----------------------+ 1 row in set ( 0.00 sec) mysql >