Skip to content

Instantly share code, notes, and snippets.

@remarkablemark

remarkablemark/UUID_TO_BIN.sql

Last active January 2, 2022 22:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save remarkablemark/33635e6694ee90081c9451920547d04d to your computer and use it in GitHub Desktop.
Save remarkablemark/33635e6694ee90081c9451920547d04d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
UUID_TO_BIN.sql
DELIMITER //
CREATE FUNCTION UUID_TO_BIN(uuid CHAR(36))
RETURNS BINARY(16) DETERMINISTIC
RETURN UNHEX(CONCAT(REPLACE(uuid, '-', ''))); //
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment