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, 799🔥, 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 Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...