webCOMAND

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')