How to format uuid string from binary column in MySQL/MariaDB

MySQL 8 adds two new UUID functions:

• UUID_TO_BIN
• BIN_TO_UUID - this is the one you're looking for

So:

SELECT BIN_TO_UUID(uuid) FROM foo

The following would create the result I was after:

SELECT
  LOWER(CONCAT(
    SUBSTR(HEX(uuid), 1, 8), '-',
    SUBSTR(HEX(uuid), 9, 4), '-',
    SUBSTR(HEX(uuid), 13, 4), '-',
    SUBSTR(HEX(uuid), 17, 4), '-',
    SUBSTR(HEX(uuid), 21)
  ))
FROM foo;