STRCMP()

The STRCMP() function is used to compare two strings str1 and str2.

Function Description

The STRCMP() function is used to compare two strings str1 and str2. If both strings are identical, it returns 0; if str1 is less than str2 according to the current character set sorting, it returns -1; if str1 is greater than str2, it returns 1. If either parameter is NULL, it returns NULL.

Function Syntax

> STRCMP(str1, str2)

Parameter Explanation

Parameter	Description
str1	Required. The first string to be compared.
str2	Required. The second string to be compared.

Examples

mysql> select strcmp('hello', 'hello') from dual;
+-------------------------+
| strcmp(hello, hello) |
+-------------------------+
| 0 |
+-------------------------+
1 row in set (0.00 sec)
mysql> select strcmp('apple', 'banana') from dual;
+---------------------------+
| strcmp(apple, banana) |
+---------------------------+
| -1 |
+---------------------------+
1 row in set (0.00 sec)
mysql> select strcmp('banana', 'apple') from dual;
+---------------------------+
| strcmp(banana, apple) |
+---------------------------+
| 1 |
+---------------------------+
1 row in set (0.00 sec)
drop table if exists t1;
CREATE TABLE t1 (str1 VARCHAR(100), str2 VARCHAR(100));
insert into t1 values('hello', 'world');
insert into t1 values('abc', 'ABC');
insert into t1 values('test', 'test');
insert into t1 values(null, 'value');
insert into t1 values('value', null);
mysql> select strcmp(str1, str2) from t1;
+-------------------+
| strcmp(str1, str2) |
+-------------------+
| -1 |
| 1 |
| 0 |
| NULL |
| NULL |
+-------------------+
5 rows in set (0.01 sec)