- ⌂ Object Information
- Functions
UUID()
Return a UUID in binary format based on a UUID string.
UUIDs are stored in binary format in the repository for best performance, so this function must be used to compare the UUID of a repository object to a UUID in string format.
Prototype
binary(32) UUID(string $uuid)
Parameters
- uuid - UUID string like '4c5c850a-da1b-11e5-bb17-fba753ab61e3' (with dashes) or '4c5c850ada1b11e5bb17fba753ab61e3' (without dashes).
Return
A 32-bit binary value.
Example
SELECT * FROM Contact WHERE UUID=UUID('4c5c850a-da1b-11e5-bb17-fba753ab61e3')