UUID_TO_BIN: https://remarkablemark.org/blog/2020/05/21/mysql-uuid-bin/

UUID_TO_BIN.sql

DELIMITER //

CREATE FUNCTION UUID_TO_BIN(uuid CHAR(36))
RETURNS BINARY(16) DETERMINISTIC
RETURN UNHEX(CONCAT(REPLACE(uuid, '-', ''))); //

DELIMITER ;