Code: Select all
DELIMITER $$
CREATE FUNCTION UUID2BIN(_uuid CHAR(36))
RETURNS BINARY(16)
DETERMINISTIC
SQL SECURITY INVOKER
RETURN
UNHEX(CONCAT(
SUBSTR(, 15, 4),
SUBSTR(, 10, 4),
SUBSTR(, 1, 8),
SUBSTR(, 20, 4),
SUBSTR(, 25) ))
$$
DELIMITER ;
"SHOW CREATE FUNCTION UUID2BIN;" shows this:
Code: Select all
CREATE DEFINER=`root`@`%` FUNCTION `UUID2BIN`(_uuid CHAR(36)) RETURNS binary(16)
DETERMINISTIC
SQL SECURITY INVOKER
RETURN
UNHEX(CONCAT(
SUBSTR(_uuid, 15, 4),
SUBSTR(_uuid, 10, 4),
SUBSTR(_uuid, 1, 8),
SUBSTR(_uuid, 20, 4),
SUBSTR(_uuid, 25) ))