MySQL8 STRCMP() Functions – String Functions

by · Published · Updated

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

STRCMP(expression1,expression2)

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().

You may also like...