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
//