3. Elements of SQL Statements
:
SQL Functions
:
UUID Functions
:
UUID_COMPARE(uuid1, uuid2) Function
Share this page
UUID_COMPARE(uuid1, uuid2) Function
The UUID_COMPARE(uuid1, uuid2) function returns an integer value:
Return
Meaning
-1
uuid1 < uuid2
0
uuid1 == uuid2
+1
uuid1 > uuid2
//
// Determine if u1 is greater than, less than, or equal to u2
//
* SELECT UUID_COMPARE(u1, u2) FROM uuidtable;
//
// u1 > u2
//