Mega Code Archive

 

Categories / MySQL / String

 

The STRCMP() compares string values that can be literal values or derived from expressions

mysql> STRCMP(<expression1>, <expression2>) mysql> mysql> SELECT STRCMP('big', 'bigger'); +-------------------------+ | STRCMP('big', 'bigger') | +-------------------------+ |                      -1 | +-------------------------+ 1 row in set (0.00 sec) mysql>