I was reminded today of the Ackermann function which is famous in computer science.
Today I discovered the PHP range function…
It was harder to find what I was looking for than seemed reasonable, but eventually I figured out that you can convert a binary field from binary into a hexadecimal string using the MySQL HEX function.
Everything is easy once you know how!
Found a list of MySQL Encryption and Compression Functions today. Handy.