Collections:
IS_UUID() - Validating UUID String Format
How to validate a UUID (Universal Unique IDentifier) string using the IS_UUID() function?
✍: FYIcenter.com
IS_UUID(uuid) is a MySQL built-in function that
validates a UUID (Universal Unique IDentifier) string.
It only checks if the given UUID is a 32-digit hexadecimal string or not.
For example:
SELECT IS_UUID('447f9022-956d-11ee-b1eb-65d6038dbafa'); -- +-------------------------------------------------+ -- | IS_UUID('447f9022-956d-11ee-b1eb-65d6038dbafa') | -- +-------------------------------------------------+ -- | 1 | -- +-------------------------------------------------+ SELECT IS_UUID('aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee'); -- +-------------------------------------------------+ -- | IS_UUID('aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee') | -- +-------------------------------------------------+ -- | 1 | -- +-------------------------------------------------+
If the UUID string is too short (less than 32 digits) or invalid characters, IS_UUID() returns 0. For example:
SELECT IS_UUID('447f9022-956d-11ee-b1eb-65d6038d'); -- +---------------------------------------------+ -- | IS_UUID('447f9022-956d-11ee-b1eb-65d6038d') | -- +---------------------------------------------+ -- | 0 | -- +---------------------------------------------+ SELECT IS_UUID('aaaaaaaa-bbbb-cccc-zzzz-eeeeeeeeeeee'); -- +-------------------------------------------------+ -- | IS_UUID('aaaaaaaa-bbbb-cccc-zzzz-eeeeeeeeeeee') | -- +-------------------------------------------------+ -- | 0 | -- +-------------------------------------------------+
Reference information of the IS_UUID() function:
IS_UUID(uuid): boolean Returns 1 if and only if the argument is a valid UUID. Arguments, return value and availability: uuid: Required. The UUID string to be validated. boolean: Return value. 1 if and only if the argument is a valid UUID. Available since MySQL 5.7.
⇒ UUID() - Generating UUID String
⇐ BIN_TO_UUID() - Converting Binary to UUID
2023-12-08, 1082🔥, 0💬
Popular Posts:
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...