STRCMP
Returns 0 if the strings are the same, -1 if the first argument is smaller than the second, and 1 otherwise.
Syntax​
STRCMP(expr1,expr2)
Arguments​
| Arguments | Description |
|---|---|
| expr1 | The string. |
| expr2 | The string. |
Return Type​
A number data type value.
Examples​
SELECT STRCMP('text', 'text2');
+-------------------------+
| STRCMP('text', 'text2') |
+-------------------------+
| -1 |
+-------------------------+
SELECT STRCMP('text2', 'text');
+-------------------------+
| STRCMP('text2', 'text') |
+-------------------------+
| 1 |
+-------------------------+
SELECT STRCMP('text', 'text');
+------------------------+
| STRCMP('text', 'text') |
+------------------------+
| 0 |
+------------------------+