MySQL8 STRCMP() Functions – String Functions

STRCMP() Functions let us compare the string according to their sort order. Both the inputs should be strings.

It will return 1, -1, or 0 depending upon the strings passed as arguments.

if expression1 >  expression2, returns 1.

if expression1 <  expression2, returns -1.

if expression1 =  expression2, returns 0.

This operator works best on strings in the English language (using it with other languages may return unreliable results).

Returns NULL if any of the argument is NULL.

---

MySQL STRCMP() : Syntax

---

MySQL STRCMP() : Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|left|left|left”]
Name, Required /Optional,Type, Description
expression1 , Required, String , It represents valid string.
expression2, Required, String , It represents valid string.
[/table]

---

MySQL STRCMP() : Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Return, Description
NULL, if any of the argument is NULL.
0, if the input strings are same.
-1, if the first argument is smaller than the second according to the current sort order
1, if the first argument is larger than the second argument.[/table]

---

MySQL STRCMP() : Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 5.7
[/table]

---

STRCMP() Example 1 : returns 0, if the input strings are same.

mysql> SELECT STRCMP('tutorialmines', 'tutorialmines');
+------------------------------------------+
| STRCMP('tutorialmines', 'tutorialmines') |
+------------------------------------------+
| 0 |
+------------------------------------------+
1 row in set (0.00 sec)

---

STRCMP() Example 2 : returns -1, if the first argument is smaller than the second according to the current sort order

Below are some more examples.

mysql> SELECT STRCMP('tutorial', 'tutorialmines');
+-------------------------------------+
| STRCMP('tutorial', 'tutorialmines') |
+-------------------------------------+
| -1 |
+-------------------------------------+
1 row in set (0.00 sec)

---

STRCMP() Example 3 : return 1, if the first argument is larger than the second argument.

See the below example :

mysql> SELECT STRCMP('tutorialmines', 'tutorial');
+-------------------------------------+
| STRCMP('tutorialmines', 'tutorial') |
+-------------------------------------+
| 1 |
+-------------------------------------+
1 row in set (0.00 sec)

---

STRCMP() Example 4 : NULL arguments

If any of the arguments is NULL, it will return NULL. See the below example :

mysql> SELECT STRCMP('tutorialmine', NULL), STRCMP( NULL, 'tutorialmines');
+------------------------------+--------------------------------+
| STRCMP('tutorialmine', NULL) | STRCMP( NULL, 'tutorialmines') |
+------------------------------+--------------------------------+
| NULL | NULL |
+------------------------------+--------------------------------+
1 row in set (0.01 sec)

---

See all MySQL String functions MySQL 8 String Functions.

---

Related articles : LOCATE(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION().

---

PHP Related articles : SUBSTR_COMPARE(), STRNCMP(), PHP STRING FUNCTIONS(), STRNCASECMP(), STRNATCASECMP().