11.3.19 STRCMP(S1,S2)函数
STRCMP(S1,S2)函数用于比较字符串S1和字符串S2的ASCII码值的大小。如果S1的ASCII码值比S2的ASCII码值小,则返回-1;如果S1的ASCII码值与S2的ASCII码值相等,则返回0;如果S1的ASCII码值大于S2的ASCII码值,则返回1。使用示例如下:
mysql> SELECT STRCMP('a', 'b'), STRCMP('c', 'b'), STRCMP('a','a');
+------------------+------------------+-----------------+
| STRCMP('a', 'b') | STRCMP('c', 'b') | STRCMP('a','a') |
+------------------+------------------+-----------------+
| -1 | 1 | 0 |
+------------------+------------------+-----------------+
1 row in set (0.00 sec)