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, 1503🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...