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, 1820🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Escape Special Characters in SQL statements in MySQL? There are a number of special character...