String MySQL

  1. Home
  2. MySQL
  3. String
  4. STRCMP( ) takes two string arguments and returns -1, 0, or 1, depending on whether the first string is lexical
ly less than, equal to, or greater than the second.
mysql>
mysql> SELECT STRCMP('Abc','abc'), STRCMP('abc','abc'), STRCMP('abc','Abc');
+---------------------+---------------------+---------------------+
| STRCMP('Abc','abc') | STRCMP('abc','abc') | STRCMP('abc','Abc') |
+---------------------+---------------------+---------------------+
|                   0 |                   0 |                   0 |
+---------------------+---------------------+---------------------+
1 row in set (0.00 sec)
mysql>